If statement to remove zeros help

Question

Hi&nbsp;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.&nbsp;Here is my statement so far but it's returning a value error=IF('[workbook1.xlsx]sheet1'!A1,'[workbook1.xlsx]sheet1'!A1,"")&nbsp;How can I fix this?

riny_van_eekelen · Answer

cheeseontoast101&nbsp;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?

lorenzo · Answer

Hi&nbsp;cheeseontoast101&nbsp;&nbsp;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)&nbsp;&nbsp;

Forum Discussion

If statement to remove zeros help

Share

Resources