Inconsistent Formula?

[andrew]

I have the following formula:

=IF((AND(ISNUMBER(T7),N7="H",T7=0)),"x",(IF(AND(ISNUMBER(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 Phillips]

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)

 

[Bernard Liengme]

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

 

[andrew]

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:S45>0)*(T7:T45-V7:V45+S7:S45>0)))

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

Any help is much appreciated, thanks!

 

[Don]

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

 

[Don]

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

 

[T. Valko]

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

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

Goto Tools>Options>Error Checking tab>Rules

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