Formula to flag if value is greater than or less than 90

[Nanaia]

How would I word a formula to flag if a cell is greater than or less than 90? I want to search 2 columns (Z and AA) and tell me if any of the values are greater than or less than 90 and exclude zero's and text by putting "BRACKET" the cell the formula is in. How would I word that in a formula?

 

[Scott T]

You want one formula to test both Columns? What if one is under 90 and the other is over 90?

 

[Nanaia]

No, one formula to check both columns from row 3 to row 500. They identify angles on the X and Y axis. If it's not a 90 degree angle (both columns are identified as numbers, not degrees). The columns being checked are on a different worksheet in the file. I want a cell on the front sheet to flag the non-standard angles so we know we'll need to address them. I hope I didn't just confuse things.

 

[JLGWhiz]

This will test if either is not equal to 90, but as Scott T points out, it will not distinguish which one is not = 90.

=IF(OR(Z2<>90, AA2 <> 90), "[]", "")

 

[Nanaia]

Cool. Thanks! I could just put the flag word we want in place of the [] can't I? I don't need it to tell me which one, that one in that row is non-standard. How do I get it to ignore the ones with zero values?

 

[Nanaia]

Wow. It stinks when there's a lag between the keyboard and the computer. That post was all sorts of messed up!
What I meant to say was:
Cool. Thanks! I could just put the flag word we want in place of the [] can't I? I don't need the formula to tell me which column has the non standard number, only identify the row somehow. I will be using the results of this formula in a TEXTJOIN formula that we want to be blank if the there is text, a zero, or a standard 90 in one of those columns, and flag it if there is any other number there.
I hope that makes more sense. Sorry about the mess.

 

[Scott T]

Does this do what you want?

Book1
	Z	AA	AB
2	text	text
3	88	90	3
4	90	99	4
5	90	90
6	text	7	6
7	69	text	7
Sheet1

Cell Formulas
Range	Formula
AB2	=IF(OR(AND(ISNUMBER(Z2),Z2<>90),AND(ISNUMBER(AA2),AA2<>90)),ROW(),"")
AB3	=IF(OR(AND(ISNUMBER(Z3),Z3<>90),AND(ISNUMBER(AA3),AA3<>90)),ROW(),"")
AB4	=IF(OR(AND(ISNUMBER(Z4),Z4<>90),AND(ISNUMBER(AA4),AA4<>90)),ROW(),"")
AB5	=IF(OR(AND(ISNUMBER(Z5),Z5<>90),AND(ISNUMBER(AA5),AA5<>90)),ROW(),"")
AB6	=IF(OR(AND(ISNUMBER(Z6),Z6<>90),AND(ISNUMBER(AA6),AA6<>90)),ROW(),"")
AB7	=IF(OR(AND(ISNUMBER(Z7),Z7<>90),AND(ISNUMBER(AA7),AA7<>90)),ROW(),"")

 

[Nanaia]

[TABLE="class: grid, width: 50"]
<tbody>[TR]
[TD]90
[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]110
[/TD]
[TD][/TD]
[TD]BRACKET
[/TD]
[/TR]
[TR]
[TD]90
[/TD]
[TD]90
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]30[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD]80
[/TD]
[TD]BRACKET
[/TD]
[/TR]
</tbody>[/TABLE]

 

[Nanaia]

Well the chart didn't show liked I'd hoped. I can't paste in here, it loses the formatting. I tried to use the site to create a chart and it wouldn't show the zero values (that's the empty cells) or the cell headers.
If first column or the second column shows anything other than 90, the panel needs a bracket. I'm trying to flag it so we know at a quick glance which ones need brackets.

 

[Scott T]

try

Excel 2010
	Z	AA	AB
2	90
3	110		BRACKET
4	90	90
5
6		80	BRACKET
Sheet1

Cell Formulas
Range	Formula
AB2	=IF(OR(AND(ISNUMBER(Z2),Z2<>90),AND(ISNUMBER(AA2),AA2<>90)),"BRACKET","")
AB3	=IF(OR(AND(ISNUMBER(Z3),Z3<>90),AND(ISNUMBER(AA3),AA3<>90)),"BRACKET","")
AB4	=IF(OR(AND(ISNUMBER(Z4),Z4<>90),AND(ISNUMBER(AA4),AA4<>90)),"BRACKET","")
AB5	=IF(OR(AND(ISNUMBER(Z5),Z5<>90),AND(ISNUMBER(AA5),AA5<>90)),"BRACKET","")
AB6	=IF(OR(AND(ISNUMBER(Z6),Z6<>90),AND(ISNUMBER(AA6),AA6<>90)),"BRACKET","")