|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
May 5th, 2010, 03:39 AM
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
May 5th, 2010, 07:21 AM
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
May 5th, 2010, 10:53 AM
posted to microsoft.public.excel.misc
|
|||
|
|||
|
Recognizing an Unstable Result
Ken;951153 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 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 -- bala_vb
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
