Recognizing an Unstable Result

[Ken]

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?

 

[BSc Chem Eng Rick]

In column C use this formula,

=IF(ISERROR(Cell_Ref),0,"")

 

[bala_vb]

In Column "B" I have a list of results. Some of them have the result o

"#VALUE!".
I would like these cells to be represented in Column "C" with th
result of
"0". What IF statement correctly tests for cells which have "#VALUE!
in them?

if you are using excel 2007 version, there is simple formulae to get i
column C

=ISERROR(B1) . it returns TRUE FOR #value, #error etc errors resulte
in exce