#VALUE
 

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

Warp your formulas in an IF statement like:

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

Vaya con Dios,
Chuck, CABGx3


"Brett" wrote in message
...
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

or use conditional formatting to hide the error.

--

HTH

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


"CLR" wrote in message
...
Warp your formulas in an IF statement like:

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

Vaya con Dios,
Chuck, CABGx3


"Brett" wrote in message
...
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