IF Formula
I need help with formula that will calculate a payout for
Basic Stretch Super Strech
63 $3.00 72 $5.00 82 $7.00
for example...
employee 1 has 65
employee 2 has 75
employee 3 has 82
I put this formula together but my amounts are not coming out correct...
=IF(B4=82,(B4*7)),IF(B472<82,(B4*5),IF(B4=63<72 (B4*3),0))
--
Still Learning...
|