Forum Discussion
cheeseontoast101
Jul 12, 2022Copper Contributor
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 o...
Riny_van_Eekelen
Jul 12, 2022Platinum Contributor
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?