ExcelBanter - Recognizing an Unstable Result

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Recognizing an Unstable Result (https://www.excelbanter.com/excel-discussion-misc-queries/263094-recognizing-unstable-result.html)

Ken

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

BSc Chem Eng Rick

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

bala_vb

Quote:

Originally Posted by Ken (Post 951153)

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

All times are GMT +1. The time now is 09:25 PM.