IF Formula

  • Thread starter Thread starter :: Amy ::
  • Start date Start date
A

:: Amy ::

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(B4>72<82,(B4*5),IF(B4>=63<72(B4*3),0))
 
Hi Amy
It's not clear what you want so I just made your formula work
=IF(B4>=82,B4*7,IF(B4>=72,B4*5,IF(B4>=63,B4*3,0)))
What if its below 63 ??
Anyway try it and post back
HTH
John
 
Back
Top