Determining True/false based on multiple criteria

**byeong** · 07-27-2012, 09:27 AM

Hi Everyone,

This might be a simple fix, but I'm having trouble coming up with the correct formula:

Basically, I'd like to determine if an activity is 'worthwhile' based on the time spent and a number rating.

The criteria is listed below:
If the activity took longer than or equal to an hour and 30 minutes, it must have a rating of 7 or above to be worthwhile
If the activity took more than or equal to an hour and 30 minutes and has a rating of 6 or below, it is not worthwhile

If the activity took less than an hour and 30 minutes, it must have a rating or 5 or above to be worthwhile
If the activity took less than an hour and 30 minutes and has a rating of 4 or below, it is not worthwhile

I'd like to display a 'yes' or 'no' for worthwhile/not worthwhile.

Thank you! worthwhile.xls

**MarvinP** · 07-27-2012, 09:35 AM

Hi byeong and welcome to the forum.

Put this in F2 and pull down.
=IF(OR(AND(E2>=7,D2>=90),AND(D2<=30,E2>=5)),"Yes","No")

**byeong** · 07-27-2012, 10:33 AM

Awesome. Thanks a lot Marvin!!!

**Cutter** · 07-27-2012, 12:04 PM

@ byeong

Based on your last post it seems that you are satisfied with the solution(s) you've received but you haven't marked your thread as SOLVED. I'll do that for you now but please keep in mind for your future threads that Rule #9 requires you to do that yourself. If your problem has not been solved you can use Thread Tools (located above your first post) and choose "Mark this thread as unsolved".
Thanks.

Also, as a relatively new member of the forum, you may not be aware that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of those who helped.