# 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
###### Who is Participating?

Commented:
Please update to the following formula.

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

Senior Infrastructure Support Analyst & Systems DeveloperCommented:
what do you want to achieve
0

Author Commented:
If cell O2 = 91+ or 31-90, then Over, if not, then under

Thanks
Seamus
0

Information Services ManagerCommented:

=IF(O2 >= 90,"Over 90",IF(O2 >=60,"60 to 90",IF(O2 >=30,"30 to 60","Under 30")))
0

Senior Infrastructure Support Analyst & Systems DeveloperCommented:
=IF((O2>30),"Over 30","Under 30")
0

Commented:
OR is using logical test.
O2 = "91+" is a logical test.
"31-90" is not a logical test.
logical-test.JPG
0

Author 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.