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

Nanaia

Active Member
Joined
Jan 11, 2018
Messages
306
Office Version
  1. 365
Platform
  1. Windows
  2. MacOS
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?
 
Last edited:
Thank you for your help. I appreciate it.
We're one step closer. It gives me "BRACKET" for every numeric value, even the zero's and 90's.
 
Upvote 0

Excel Facts

How to create a cell-sized chart?
Tiny charts, called Sparklines, were added to Excel 2010. Look for Sparklines on the Insert tab.
Are the values from a formula? Do you have formatting that is not showing decimal places? The number is 90.000001 then it is not equal to 90 and the formula will return BRACKET.


Excel 2010
ZAAAB
290 
3110BRACKET
49090 
500 
680BRACKET
7 
Sheet1
Cell Formulas
RangeFormula
AB2=IF(OR(AND(ISNUMBER(Z2),Z2<>90,Z2<>0),AND(ISNUMBER(AA2),AA2<>90,AA2<>0)),"BRACKET","")
AB3=IF(OR(AND(ISNUMBER(Z3),Z3<>90,Z3<>0),AND(ISNUMBER(AA3),AA3<>90,AA3<>0)),"BRACKET","")
AB4=IF(OR(AND(ISNUMBER(Z4),Z4<>90,Z4<>0),AND(ISNUMBER(AA4),AA4<>90,AA4<>0)),"BRACKET","")
AB5=IF(OR(AND(ISNUMBER(Z5),Z5<>90,Z5<>0),AND(ISNUMBER(AA5),AA5<>90,AA5<>0)),"BRACKET","")
AB6=IF(OR(AND(ISNUMBER(Z6),Z6<>90,Z6<>0),AND(ISNUMBER(AA6),AA6<>90,AA6<>0)),"BRACKET","")
AB7=IF(OR(AND(ISNUMBER(Z7),Z7<>90,Z7<>0),AND(ISNUMBER(AA7),AA7<>90,AA7<>0)),"BRACKET","")
 
Upvote 0
The cells being read are from a CSV that we copy and paste without changing anything (per the boss). Columns Z & AA contain whole numbers only, no formulae. The cell formatting is "general".
Your revision resolved it. Awesome!
Thank you!! You're a rockstar!
 
Upvote 0

Forum statistics

Threads
1,223,911
Messages
6,175,333
Members
452,636
Latest member
laura12345

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top