Is this any better

=IF(AND(ISNUMBER(T7),N7="H"),IF(T7=0,"x","R"),"")

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"andrew" wrote in message
...
I have the following formula:

=IF((AND(ISNUMBER(T7),N7="H",T7=0)),"x",(IF(AND(IS NUMBER(T7),N7="H",T7<0),"R","")))

The formula above is able to provide a result, but I keep getting the
'triangle tab' on the top left of the cell saying that this is
inconsistent.
Due to this, it has also affected my other formula cells - some which
returned "Value Not Available" error.

Any ideas?