Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
need help making a formula
i need to make a formula that will show a commission rate of 5% sales over
15,000 with a 3% sales commission for lesser sales. Could someone please help me with this. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
need help making a formula
A1: (a sales amount)
B1: =A1*.03+MAX(A1-15000,0)*.02 Is that something you can work with? -------------------------- Regards, Ron Microsoft MVP (Excel) (XL2003, Win XP) "kath" wrote in message ... i need to make a formula that will show a commission rate of 5% sales over 15,000 with a 3% sales commission for lesser sales. Could someone please help me with this. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
need help making a formula
Actually, if you use what I posted, it will fix itself.
This: B1: =A1*.03+MAX(A1-15000,0)*.02 will become this: B1: =A1*0.03+MAX(A1-15000,0)*0.02 (zeros preceding the decimal points) -------------------------- Regards, Ron Microsoft MVP (Excel) (XL2003, Win XP) "Ron Coderre" wrote in message ... A1: (a sales amount) B1: =A1*.03+MAX(A1-15000,0)*.02 Is that something you can work with? -------------------------- Regards, Ron Microsoft MVP (Excel) (XL2003, Win XP) "kath" wrote in message ... i need to make a formula that will show a commission rate of 5% sales over 15,000 with a 3% sales commission for lesser sales. Could someone please help me with this. |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
need help making a formula
Does that mean if the sales were 27,336 -
3% of the first 15,000 + 5% of the next 12,336 ? If that's the case: A1 = 27,336 =IF(A1="",0,MIN(A1,15000)*0.03+MAX(A1-15000,0)*0.05) Commisson = 1066.80 -- Biff Microsoft Excel MVP "kath" wrote in message ... i need to make a formula that will show a commission rate of 5% sales over 15,000 with a 3% sales commission for lesser sales. Could someone please help me with this. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Making too much of a formula | Excel Worksheet Functions | |||
Making my Formula F1 Race | Excel Discussion (Misc queries) | |||
Making a formula using letters | Excel Discussion (Misc queries) | |||
Making this formula work | Excel Worksheet Functions | |||
Making a formula continuous | Excel Discussion (Misc queries) |