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

Formulas and Functions

2 Replies

  • Riny_van_Eekelen's avatar
    Riny_van_Eekelen
    Platinum Contributor
    Mar 28, 2020

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

  • 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