IF Formulas

[:: Amy ::]

I need help building a formula for payouts

Basic Stretch Super Strech
63 $3.00 72 $5.00 82 $7.00

employee 1 has 85
employee 2 has 72
employee 3 has 71
(if employee is under 63 then there is no payout = $0.00)

 

[Megan]

I would set it up as follows let's say starting in A1:
Super Stretch 82 7
Stretch 72 81 5
Basic 63 71 3
None 0 62 0

The below would start in A7:
Employee 1 85
Employee 2 72
Employee 3 71

The below formula would be in cell C7
=IF(B7>=$B$1,$D$1,IF(B7>=$B$2,$D$2,IF(B7>=$B$3,$D$3,IF(B7>=$B$4,$D$4))))