Cell Referencing and IF(Blank) make it " " if else put data from reference cell in

[Acousticlife81]

I am trying to take a sheet that is referenced from another sheet and display if it is empty put " " if not " " or empty then display the information inside the cell.


='J:\Systems\Data\User\A\[A (2).xlsm]Cover'!B15

I was trying to do this but I know this is not right

=IF(a1=" "', J:\Systems\Data\User\A\[A (2).xlsm]Cover'!B15), IF a1=J:\Systems\Data\User\A\[A (2).xlsm]Cover'!B15)

Please let me know if anyone can help.

Thanks,

-J

[TMS]

There is a difference between an empty cell, which you would test for with two double quotes ( "" ) and a cell with a single space in it which you would test for with double quote, space, double quote ( " " ).

Which do you need?

That said, I don't really understand what the formula is intended to achieve. Please spell it out (in words).