#VALUE

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
or use conditional formatting to hide the error.

--

HTH

RP
(remove nothere from the email address if mailing direct)
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Scrabble Value calculation for Welsh words 0
Image not displaying in datagridview column in vb.net 1
#value error for sumproduct using RIGHT cmd 0
Look up or Match Function? Excuse my ignornace. This could be simple.Variable Upgrades on Furniture 1
Excel VBA 1
Conditionally Formatting Cells based on Values in a Range (2007) 3
resettable, over-ridable, default cell values 0
Excel Help to copy information from one row at a time to another sheet 1

Back
Top