Recognizing an Unstable Result

  • Thread starter Thread starter Ken
  • Start date Start date
K

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?
 
Ken;951153 said:
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?
Click to expand...


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
 
Back
Top