Testing cell value for greater than 0
 

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

Testing cell value for greater than 0
 

"Raj" wrote:
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), A10, 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 -----

"Raj" wrote in message
...
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