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?

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?

Bob has given you a better formula but let's address the other issues.
"Inconsistent" is just a warning telling you that a formula <appears to be
inconsistent with formulas in nearby cells. It is not a indication of that
there is an actual error. Therefore this triangle cannot have any affect on
other cells.
best wishes
--
Bernard Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme

"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?

Thanks guys. The shortened formula makes it easier to understand.

What about error messages like #N/A?

I have another formula that acts weirdly and only certain cells produces the
above error in the same cell across 10 worksheets. Here's and example:

=SUM(IF((FREQUENCY(IF(T7:T45=0,ROW(T7:T45)),IF(T7: T45<0,ROW(T7:T45),0))=3)*(1-FREQUENCY(2,--T7:T45)),(S7:S450)*(T7:T45-V7:V45+S7:S450)))

*refer to my earlier post titled 'Part 2 - Counting series of text/number
sequence'

Any help is much appreciated, thanks!

"Bernard Liengme" wrote:

Bob has given you a better formula but let's address the other issues.
"Inconsistent" is just a warning telling you that a formula <appears to be
inconsistent with formulas in nearby cells. It is not a indication of that
there is an actual error. Therefore this triangle cannot have any affect on
other cells.
best wishes
--
Bernard Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme

"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?

More often than not there is not an error. It is very irritating to have it
clutter up the sheet. Is there any way to disable it or remove all the
checked cells at once? Very often when you enter a formula many other cells
light up with green warning flags which waste a lot time required to remove
them.
Don

"Bernard Liengme" wrote:

Bob has given you a better formula but let's address the other issues.
"Inconsistent" is just a warning telling you that a formula <appears to be
inconsistent with formulas in nearby cells. It is not a indication of that
there is an actual error. Therefore this triangle cannot have any affect on
other cells.
best wishes
--
Bernard Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme

"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?

My previous reply failed to transmit.
More often than not there is no error. It is very irritating to have the
sheet cluttered up. Is there any way to disable this usually erroneous (never
had a bonafide one) warning? Very often entering one formula results in many
green warning flags which have to be removed one at a time. Any way to remove
all at once?
Don

"Bernard Liengme" wrote:

Bob has given you a better formula but let's address the other issues.
"Inconsistent" is just a warning telling you that a formula <appears to be
inconsistent with formulas in nearby cells. It is not a indication of that
there is an actual error. Therefore this triangle cannot have any affect on
other cells.
best wishes
--
Bernard Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme

"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?

Is there any way to disable this usually erroneous...warning?

This is very annoying and I have *all* of these "warnings" turned off:

Goto ToolsOptionsError Checking tabRules

Uncheck the ones you want. I have them *all* unchecked.

--
Biff
Microsoft Excel MVP


"Don" wrote in message
...
My previous reply failed to transmit.
More often than not there is no error. It is very irritating to have the
sheet cluttered up. Is there any way to disable this usually erroneous
(never
had a bonafide one) warning? Very often entering one formula results in
many
green warning flags which have to be removed one at a time. Any way to
remove
all at once?
Don

"Bernard Liengme" wrote:

Bob has given you a better formula but let's address the other issues.
"Inconsistent" is just a warning telling you that a formula <appears to
be
inconsistent with formulas in nearby cells. It is not a indication of
that
there is an actual error. Therefore this triangle cannot have any affect
on
other cells.
best wishes
--
Bernard Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme

"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?