IF/OR Statement

Hi, can someone amend the below, im getting an value error message

=IF(OR(O2="91+","31-90"),"Over 30","Under 30")

Thanks
Seamus
Seamus2626Asked:
Who is Participating?
 
royhsiaoCommented:
Please update to the following formula.

=IF(OR(O2="91+",O2="31-90"),"Over 30","Under 30")
0
 
Raheman M. AbdulSenior Infrastructure Support Analyst & Systems DeveloperCommented:
what do you want to achieve
0
 
Seamus2626Author Commented:
If cell O2 = 91+ or 31-90, then Over, if not, then under

Thanks
Seamus
0
Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

 
Ron MalmsteadInformation Services ManagerCommented:
Try this instead...

=IF(O2 >= 90,"Over 90",IF(O2 >=60,"60 to 90",IF(O2 >=30,"30 to 60","Under 30")))
0
 
Raheman M. AbdulSenior Infrastructure Support Analyst & Systems DeveloperCommented:
=IF((O2>30),"Over 30","Under 30")
0
 
royhsiaoCommented:
OR is using logical test.
O2 = "91+" is a logical test.
"31-90" is not a logical test.
logical-test.JPG
0
 
Seamus2626Author Commented:
Thanks all, this was the solution that worked.

Cheers,
Seamus
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.