Forum Discussion

Misbah's avatar
Misbah
Copper Contributor
Mar 28, 2020

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...
Formulas and Functions
Phobosd's avatar
Phobosd
Copper Contributor
Mar 28, 2020

Misbah Hi!

 

Use "IF" construction like this: =IF(ISBLANK(A1:A5); ""; YOUR FORMULAE);

Replace "A1:A5" with cells you rely on and that should be completed.

Resources