Prev: worksheet_change becoming active just by entering the cell
Next: find mac address of my own computer by excell macro
From: oldjay on 12 Mar 2010 11:06
I want to display a message in a cell if the cell returns #Value!
From: Paul C on 12 Mar 2010 11:18
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
--
If this helps, please remember to click yes.


"oldjay" wrote:

> I want to display a message in a cell if the cell returns #Value!
 | 
Pages: 1
Prev: worksheet_change becoming active just by entering the cell
Next: find mac address of my own computer by excell macro