If statement to remove zeros help

Copper Contributor

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

@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?

Screenshot 2022-07-12 at 06.08.51.png

Hi @cheeseontoast101 

 

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)