|
IF THEn Formula
I need the formula to multiply by 3 diferent rates base on the following
assumptions if a<10,000,a*0.08,if a10001,a*0.06, if a20001,a*0.04. can anyone help ? |
IF THEn Formula
I sure hope that's not a Sales Commssion scale..........
Vaya con Dios, Chuck, CABGx3 " wrote: I need the formula to multiply by 3 diferent rates base on the following assumptions if a<10,000,a*0.08,if a10001,a*0.06, if a20001,a*0.04. can anyone help ? |
IF THEn Formula
=IF(A1<10000,A1*0.08,IF( A120001,A1*0.04,A1*0.06))
Laura Cook " wrote in message ... I need the formula to multiply by 3 diferent rates base on the following assumptions if a<10,000,a*0.08,if a10001,a*0.06, if a20001,a*0.04. can anyone help ? |
IF THEn Formula
On 1 Feb, 18:48,
wrote: I need the formula to multiply by 3 diferent rates base on the following assumptions if a<10,000,a*0.08,if a10001,a*0.06, if a20001,a*0.04. can anyone help ? =IF(A1<10000, A1*0.08,IF(A120001, A1*0.04,IF(A110001,A1*0.06))) And that should do the trick. Hope this helps, Matt http://teachr.blogspot.com |
IF THEn Formula
=if(a120000,.04,if(a210000,.06,.08)) -- Don Guillett Microsoft MVP Excel SalesAid Software " wrote in message ... I need the formula to multiply by 3 diferent rates base on the following assumptions if a<10,000,a*0.08,if a10001,a*0.06, if a20001,a*0.04. can anyone help ? |
IF THEn Formula
it is. Any help ?
"CLR" wrote: I sure hope that's not a Sales Commssion scale.......... Vaya con Dios, Chuck, CABGx3 " wrote: I need the formula to multiply by 3 diferent rates base on the following assumptions if a<10,000,a*0.08,if a10001,a*0.06, if a20001,a*0.04. can anyone help ? |
IF THEn Formula
You may wish to consider something like this..........
=IF(A120000,10000*0.08+10000*0.06+0.08*(A1-20000),IF(A110000,10000*0.08+0.06*(A1-10000),0.08*A1)) This way, the more the person sells, the more money they make. Vaya con Dios, Chuck, CABGx3 " wrote: it is. Any help ? "CLR" wrote: I sure hope that's not a Sales Commssion scale.......... Vaya con Dios, Chuck, CABGx3 " wrote: I need the formula to multiply by 3 diferent rates base on the following assumptions if a<10,000,a*0.08,if a10001,a*0.06, if a20001,a*0.04. can anyone help ? |
IF THEn Formula
I think that Chuck may have been alluding to the fact that with your figures
as salesman gets 800 commission for 10,000 but gets LESS than that for all values up to 13,333! Similarly he gets 1,200 commission for 20,000 but needs to to more than 30,000 before he will get that much again. From the information you gave it is not clear what you want for exactly 10,000. I am going to assume that you meant <=10,000 adjust the formula if not: =A1*(4-(A110000)-(A120000))*0.02 -- HTH Sandy In Perth, the ancient capital of Scotland and the crowning place of kings Replace @mailinator.com with @tiscali.co.uk " wrote in message ... it is. Any help ? "CLR" wrote: I sure hope that's not a Sales Commssion scale.......... Vaya con Dios, Chuck, CABGx3 " wrote: I need the formula to multiply by 3 diferent rates base on the following assumptions if a<10,000,a*0.08,if a10001,a*0.06, if a20001,a*0.04. can anyone help ? |
IF THEn Formula
One more to ponder.
=LOOKUP(A1,{0,10002,20002},{0.08,0.06,0.04})*A1 Gord Dibben MS Excel MVP On Fri, 1 Feb 2008 10:48:00 -0800, wrote: I need the formula to multiply by 3 diferent rates base on the following assumptions if a<10,000,a*0.08,if a10001,a*0.06, if a20001,a*0.04. can anyone help ? |
IF THEn Formula
Hi,
It's not actually the way you stated it, but did you mean for the split to go like this? Sales of 23000 would be paid like follows 10000 at 8% plus 10000 at 6% plus 3000 at 4% If that is the case take a look at John McGimpsey's site http://www.mcgimpsey.com/excel/variablerate.html HTH Martin " wrote in message ... I need the formula to multiply by 3 diferent rates base on the following assumptions if a<10,000,a*0.08,if a10001,a*0.06, if a20001,a*0.04. can anyone help ? |
IF THEn Formula
Good point Martin
Gord On Sat, 2 Feb 2008 09:21:38 +1000, "MartinW" wrote: Hi, It's not actually the way you stated it, but did you mean for the split to go like this? Sales of 23000 would be paid like follows 10000 at 8% plus 10000 at 6% plus 3000 at 4% If that is the case take a look at John McGimpsey's site http://www.mcgimpsey.com/excel/variablerate.html HTH Martin " wrote in message ... I need the formula to multiply by 3 diferent rates base on the following assumptions if a<10,000,a*0.08,if a10001,a*0.06, if a20001,a*0.04. can anyone help ? |
IF THEn Formula
Hmmmm...........typeo here's correction........
=IF(A120000,10000*0.08+10000*0.06+0.04*(A1-20000),IF(A110000,10000*0.08+0. 06*(A1-10000),0.08*A1)) Vaya con Dios, Chuck, CABGx3 "CLR" wrote in message ... You may wish to consider something like this.......... =IF(A120000,10000*0.08+10000*0.06+0.08*(A1-20000),IF(A110000,10000*0.08+0. 06*(A1-10000),0.08*A1)) This way, the more the person sells, the more money they make. Vaya con Dios, Chuck, CABGx3 " wrote: it is. Any help ? "CLR" wrote: I sure hope that's not a Sales Commssion scale.......... Vaya con Dios, Chuck, CABGx3 " wrote: I need the formula to multiply by 3 diferent rates base on the following assumptions if a<10,000,a*0.08,if a10001,a*0.06, if a20001,a*0.04. can anyone help ? |
IF THEn Formula
if a<10,000,a*0.08,if a10001,a*0.06, if a20001,a*0.04
You almost have the formula correct as you presented the issue. You must keep in mind that the IF/THEN/ELSE function will stop considering conditions, when the first TRUE path has been determined. I also use the = and <= conditional operative. =if(A1=20,000,A1*0.04,(A1<=10000,A1*0.08, A1*0.06)) -OR- =if(A1<=10,000,A1*0.08,(A1=20000,A1*0.04, A1*0.06)) However, I like the format of showing the percentage rather than the decimal equivalent as follows; =if(A1<=10,000,A1*8%,(A1=20000,A1*4%, A1*6%)) |
| All times are GMT +1. The time now is 04:01 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com