hidding #VALUE!

[Don Preston]

No available data in primary source data cells causes #VALUE! to appear in those cells with formula that refer to these empty cells. Is there something I can add to the formula to blank out the cells appearance until data is available?

 

[SirJB7]

Hi, Don Preston!
Despite of the fact that:
=SUM(V13/$K13)-1
is the same as:
=V13/$K13-1
you can use this:
=IFERROR(SUM(V13/$K13)-1,"")
or:
=IFERROR(V13/$K13-1,"")
Regards!

 

[Don Preston]

Hi, Don Preston!
Despite of the fact that:
=SUM(V13/$K13)-1
is the same as:
=V13/$K13-1
you can use this:
=IFERROR(SUM(V13/$K13)-1,"")
or:
=IFERROR(V13/$K13-1,"")
Regards!

Thank you once again. As you must know, you save us a lot of time. Gratefully, DRP

 

[SirJB7]

Hi, Don Preston!
Glad you solved it. Thanks for your feedback and for your kind words too. And welcome back whenever needed or wanted.
Regards!
PS: Please quote relevant excerpts and not the whole message unless required, it makes the topic more readable.