Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
#Value! cell
I want to display a message in a cell if the cell returns #Value!
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
#Value! cell
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! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Code to copy the formulae of one cell to all the cell in the rangewith the specific cell and columnnumber changing Options | Excel Discussion (Misc queries) | |||
Populate a cell if values in cell 1 and cell 2 match cell 3 and 4 | Excel Worksheet Functions | |||
Populate a cell if values in cell 1 and cell 2 match cell 3 and 4 | Excel Programming | |||
NEED VBA TO SELECT A CELL; NOTE THE CELL VALUE;COPYADJ CELL;FIND CELL VALUE IN A RANGE AND SO ON | Excel Programming | |||
How to create/run "cell A equals Cell B put Cell C info in Cell D | Excel Discussion (Misc queries) |