Testing cell value for greater than 0

[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

 

[Joe User]

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?

=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 -----