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