Thread: #VALUE
View Single Post
  #2   Report Post  
CLR
 
Posts: n/a
Default

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