Link to home
Start Free TrialLog in
Avatar of Seamus2626
Seamus2626Flag for Ireland

asked on

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
Avatar of Raheman M. Abdul
Raheman M. Abdul
Flag of United Kingdom of Great Britain and Northern Ireland image
what do you want to achieve
Avatar of Seamus2626
Seamus2626
Flag of Ireland image

ASKER

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

Thanks
Seamus
Avatar of Ron Malmstead
Ron Malmstead
Flag of United States of America image
Try this instead...

=IF(O2 >= 90,"Over 90",IF(O2 >=60,"60 to 90",IF(O2 >=30,"30 to 60","Under 30")))
ASKER CERTIFIED SOLUTION
Avatar of Member_2_6169280
Member_2_6169280
Flag of United States of America image
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Raheman M. Abdul
Raheman M. Abdul
Flag of United Kingdom of Great Britain and Northern Ireland image
=IF((O2>30),"Over 30","Under 30")
Avatar of Member_2_6169280
Member_2_6169280
Flag of United States of America image
OR is using logical test.
O2 = "91+" is a logical test.
"31-90" is not a logical test.
logical-test.JPG
Avatar of Seamus2626
Seamus2626
Flag of Ireland image

ASKER

Thanks all, this was the solution that worked.

Cheers,
Seamus