#Value! cell

  • Thread starter Thread starter oldjay
  • Start date Start date
In Excel 2007 use the IFERROR
IFERROR(A1+b1,"You have an error")

in Excel 2003 IFERROR is not available, but you can use ISERROR
IF(ISERROR(A1+B1),"You have an error",A1+B1)

If you really want to get specific and only trigger on #VALUE and not all
errors check out the ERROR.TYPE function in help
 
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

Vlookup result in a message box 10
I want to make One Cell mandatory if another cell has a specific value , can anyone help me? 0
Write to intersect of a row and column 7
How to retrieve number of visible digits after decimal point in VBA 5
VBA Countif across sheets? 5
best way protect unprotected cells 2
lastrow function help 6
Variable Range Copy... 13

Back
Top