How to ignore Blank cells in formula and not to show any data

[Ramadan2512]

I Have a workbook which is collecting data from another workbook "Oct" through simple formula (='D:\Desktop\Oct.xlsm'!Table1[@Column6])
my probelm is that when a cell is blank in the source workbook I get "0" in the cells of the collecting sheet and if there is a date cell empty in the sorurce I get "00.01.00"

please let me know how to make the formula display the blank cells as blank and only to show the cells that contain data

 

[Alex Blakenburg]

Try something like:

=LET(result, your_formula, IF(result="","",result))

replace "your_formula" with the formula you are currently using.

 

[Ramadan2512]

Try something like:

=LET(result, your_formula, IF(result="","",result))

replace "your_formula" with the formula you are currently using.

ok I tried it it's ok with text cells but when a cell has a date I see that date value changed to another date
how to fix that

 

[Ramadan2512]

Try something like:

=LET(result, your_formula, IF(result="","",result))

replace "your_formula" with the formula you are currently using.

it's ok Mr. Alex working perfectly - thank you for your help

 

[Alex Blakenburg]

result is just a variable name and can be whatever word or letters you want to use.
in this case result will hold whatever value the next part after the comma returns ie 'D:\Desktop\Oct.xlsm'!Table1[@Column6]

=LET(result, 'D:\Desktop\Oct.xlsm'!Table1[@Column6], IF(result="","",result))

without the let it would look like this:

=IF('D:\Desktop\Oct.xlsm'!Table1[@Column6]="", "", 'D:\Desktop\Oct.xlsm'!Table1[@Column6]))

The Let command format looks something like the below. It is 1 or more value pairs with the final item that is not a pair being the output:

=let(name1,name_value1,
     name2,name_value2,
     name3,name_value3,
     Final_Calculation_Or_Output)

 

[Alex Blakenburg]

it's ok Mr. Alex working perfectly - thank you for your help

That's great. Thanks for letting me know.