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
|