Hiding #VALUE!

D

Digital2k

I have a column with formulas, and when there is no data to calculate I get
a #VALUE! I would like to hide #VALUE!
Can anyone point me in the right direction?
Thanks
Digital2k
 
C

Chip Pearson

You might try writing your formulas like

=IF(ISERROR(your_formula),"",your_formula)

The disadvantage of such an approach it that your_formula will
often be calculated twice, resulting in a performance hit.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
 
D

Dave Peterson

You have a couple of options...

=if(iserror(yourformula),"",yourformula)

You may be able to just use the portion of the formula that causes the error.

Another option is to use Format|conditonal formatting to hide the error (white
font on white fill???).
 
D

daddylonglegs

If your formula is referencing only one cell, e.g. A1 then use

=IF(A1="","",your_formula)

There may be a simpler way, waht's the formula?
 
Top