#VALUE

B

Brett

Help needed (again).
Whenever I don't use some cells in a column where I have a formula I have
the following shown as default
#VALUE
How do I get rid of this or display something else, like a ?

Thanks in advance
 
C

CLR

Warp your formulas in an IF statement like:

=IF(ISERR(YourFormula),"?",YourFormula)

Vaya con Dios,
Chuck, CABGx3
 
B

Bob Phillips

or use conditional formatting to hide the error.

--

HTH

RP
(remove nothere from the email address if mailing direct)
 
Top