#VALUE!

  • Thread starter Thread starter dwolf
  • Start date Start date
OR

Page Setup / Sheet / Cell errors as: (choose blank; default is displayed)

- this is only for printing pages (error is not displayed)

- IF(ISERROR) for hide message "error" when sheet is displayed
 
Trap for data that would create the error in the first place.

Elsewise =IF(ISERROR(D1*F1),"",D1*F1)

in 2007 =IFERROR(D1*F1,"")


Gord Dibben MS Excel MVP
 
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

PowerPoint Powerpoint image ordering on a single slide 3
Using AutoFilter from VBA 1
retrieving values from a certain column 2
Continue Excel to New Uear 9
including zero values in a pivot table 2
Filter pivot table zero values 1
Run Macro If Cell have "x" value 0
Excel chart - great variation in values 1

Back
Top