If error #NUM! or less than 1

  • Thread starter Thread starter art
  • Start date Start date
A

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
 
Yes. Thanks. I was trying to do it with the OR function, but it didn't work.
Thanks anyways.

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

Art
 
Back
Top