Forum Discussion
Misbah
Mar 28, 2020Copper Contributor
How do I prevent a value being show before a formula is complete?
Hi, please can someone help me .... I have put formulas into Excel which rely on certain cells being completed. How do I prevent a '0' or and error message being displayed before the cells are compl...
Riny_van_Eekelen
Mar 28, 2020Platinum Contributor
Use the following formula to return a blank when a formula results in an error.
=IFERROR(<your formula>,"")Apply a custom format like "0;;;@" to the cell that contains this formula to display zeros as blank (see picture below).