Testing cell value for greater than 0

  • Thread starter Thread starter Raj
  • Start date Start date
R

Raj

Hi,

The value in a cell is derived from a formula and can be one of the
following:
NA error
Number
Null

I need TRUE to be returned when the cell value is greater than 0. This
test fails as an error is returned when the cell value is an error How
do I fix this?

Thanks in advance for all the help.

Regards,
Raj
 
Raj said:
I need TRUE to be returned when the cell value
is greater than 0. This test fails as an error
is returned when the cell value is an error How
do I fix this?
Click to expand...

=IF(ISNUMBER(A1), A1>0, FALSE)

Note: Technically, you don't need the ",FALSE" part. But I consider it
poor form without it, and it's a bad habit that will bite you in other
circumstances.


----- original message -----
 
Back
Top