• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 254
  • Last Modified:

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
0
Seamus2626
Asked:
Seamus2626
  • 2
  • 2
  • 2
  • +1
1 Solution
 
Raheman M. AbdulCommented:
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
 
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
Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

 
royhsiaoCommented:
Please update to the following formula.

=IF(OR(O2="91+",O2="31-90"),"Over 30","Under 30")
0
 
Raheman M. AbdulCommented:
=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

Featured Post

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

  • 2
  • 2
  • 2
  • +1
Tackle projects and never again get stuck behind a technical roadblock.
Join Now