If error #NUM! or less than 1
 

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

If error #NUM! or less than 1
 

Do you mean

=IF(ISERROR(C2),"",IF(C20,C2,""))

If this post helps click Yes
---------------
Jacob Skaria


"art" wrote:

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

If error #NUM! or less than 1
 

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

Art

"Jacob Skaria" wrote:

Do you mean

=IF(ISERROR(C2),"",IF(C20,C2,""))

If this post helps click Yes
---------------
Jacob Skaria


"art" wrote:

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

If error #NUM! or less than 1
 

With OR when you check the condition IF =0 it returns error..
--
If this post helps click Yes
---------------
Jacob Skaria


"art" wrote:

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

Art

"Jacob Skaria" wrote:

Do you mean

=IF(ISERROR(C2),"",IF(C20,C2,""))

If this post helps click Yes
---------------
Jacob Skaria


"art" wrote:

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