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...

IF Formula
 

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
":: Amy ::" <:: Amy wrote in message
...
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...