Forum Discussion
If statement to remove zeros help
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?
2 Replies
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)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?
