How do I prevent a value being show before a formula is complete?

[Misbah]

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

[#2]

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

[#3]

@Misbah 

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).