IF AND or IF OR formula??

**rwhite713** · 07-14-2010, 03:23 PM

C5 is age D5 is points E5 is tees F5 is handicap

in cell E5 there are 3 possible tee options, Green (G), White (W) and Blue (B)

criteria for G tees as follows:
age 70 or more
and/or age plus handicap = 80 or more

criteria for W tees as follows:
age 65 or more
and/or age plus handicap = 70 to 79

criteria for B tees as follows:
age plus handicap is less than 69

What is the correct formula for E5? I think I need something like: (worksheet is attached)
IF(C5>70,"G",IF(AND(C5+F5>=80,"G",IF(AND(C5>65,"W",IF(AND(C5+F5>69,>70,"W"IF(AND(C5+F5<69,"B"))))

**daddylonglegs** · 07-14-2010, 03:32 PM

Try

=IF(OR(C5>=70,C5+F5>=80),"G",IF(OR(C5>=65,C5+F5>=70),"W","B"))

**rwhite713** · 07-14-2010, 04:23 PM

this works except if he is 64 years old and has to get 32 points that would make him a 69 (age + HC) and he should be on the white tees (W). This formula puts him on the greens (G)?
=IF(OR(C5>=70,C5+F5>=80),"G",IF(OR(C5>=65,C5+F5>=70),"W","B"))