Jul 11 2022 06:04 PM
Hi
I'm trying to write an if statement to remove any zeros that display when the cell in the other linked work book is blank. The cell in the other workbook with be filled with text not numbers or dates, however.
Here is my statement so far but it's returning a value error
=IF('[workbook1.xlsx]sheet1'!A1,'[workbook1.xlsx]sheet1'!A1,"")
How can I fix this?
Jul 11 2022 09:11 PM
@cheeseontoast101 Used your formula and this is what I get. Note, Worbook1.xlsx is the one on the left (in the background). Is this not what you want?
Jul 11 2022 09:20 PM
If The cell in the other workbook with be filled with text not numbers or dates:
=IF(ISBLANK([workbook1.xlsx]Sheet1!A1), "", [workbook1.xlsx]Sheet1!A1)