Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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... |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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... |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|