If error #NUM! or less than 1

[art]

Hello:

I have a range of cells that have the possibilties of having either a
number, #NUM!, or 0 (zero). I want to use a formula to check if the cell has
a number (more than 0), then it should give me that number or else (whether
it has a zero value or #NUM!) it should be empty ("").

So If I have in C2 the #NUM! and in A1 the folrmula to check if C2 has more
than 0, it should stay empty, etc.

Thanks for any help.

Art

 

[Jacob Skaria]

Do you mean

=IF(ISERROR(C2),"",IF(C2>0,C2,""))

If this post helps click Yes

 

[Jacob Skaria]

Do you mean

=IF(ISERROR(C2),"",IF(C2>0,C2,""))

If this post helps click Yes

 

[art]

Yes. Thanks. I was trying to do it with the OR function, but it didn't work.
Thanks anyways.

Art

 

[art]

Yes. Thanks. I was trying to do it with the OR function, but it didn't work.
Thanks anyways.

Art

 

[Jacob Skaria]

With OR when you check the condition IF =0 it returns error..

 

[Jacob Skaria]

With OR when you check the condition IF =0 it returns error..