| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Recognizing an Unstable Result
In Column "B" I have a list of results. Some of them have the result of
"#VALUE!". I would like these cells to be represented in Column "C" with the result of "0". What IF statement correctly tests for cells which have "#VALUE!" in them? -- Ken |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Recognizing an Unstable Result
In column C use this formula,
=IF(ISERROR(Cell_Ref),0,"") -- If this helps, please click "Yes" <<<<<<<<<<< "Ken" wrote: In Column "B" I have a list of results. Some of them have the result of "#VALUE!". I would like these cells to be represented in Column "C" with the result of "0". What IF statement correctly tests for cells which have "#VALUE!" in them? -- Ken |
|
#3
|
|||
|
|||
Quote:
if you are using excel 2007 version, there is simple formulae to get in column C =ISERROR(B1) . it returns TRUE FOR #value, #error etc errors resulted in excel
__________________
Thanks Bala |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Recognizing Unstable Values in Excel | Excel Discussion (Misc queries) | |||
| mouse pointer unstable | Excel Discussion (Misc queries) | |||
| Excel 97 unstable | Setting up and Configuration of Excel | |||
| The world is really unstable these days...... | Excel Worksheet Functions | |||
| The world is really unstable these days...... | Excel Discussion (Misc queries) | |||
Hybrid Mode
