Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
formula I can't figure it out?! ARGH
I am trying to make the following formula work and am going nuts trying to
make it work - I even called Microsoft and they couldn't do it either? Here is what I am trying to do. I want say cell A1 (this will be the variable) from 0 to 100,000 multiply by 6% from 100,000 to 125,0000 multiply by 9% from 125,000 to 150,0000 multilpy by 12% from 150,000 and up multiply by 13% so if A1 was 175,000, the first 100,000 is at 6% (6,000) the next 25,000 is at 9% (2,250) the next 25,000 is at 12% (3,000) the next 25,000 is at 13% (3,250) the total would be $14,500. This is a bonus calculation so A1 is the revenue that bonus is calculated. Does anyone have any ideas! I would be forever grateful! Thanks Jewels |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
formula I can't figure it out?! ARGH
Take a look he
http://www.mcgimpsey.com/excel/variablerate.html In article , jewels wrote: I am trying to make the following formula work and am going nuts trying to make it work - I even called Microsoft and they couldn't do it either? Here is what I am trying to do. I want say cell A1 (this will be the variable) from 0 to 100,000 multiply by 6% from 100,000 to 125,0000 multiply by 9% from 125,000 to 150,0000 multilpy by 12% from 150,000 and up multiply by 13% so if A1 was 175,000, the first 100,000 is at 6% (6,000) the next 25,000 is at 9% (2,250) the next 25,000 is at 12% (3,000) the next 25,000 is at 13% (3,250) the total would be $14,500. This is a bonus calculation so A1 is the revenue that bonus is calculated. Does anyone have any ideas! I would be forever grateful! Thanks Jewels |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
formula I can't figure it out?! ARGH
=MAX(6%*A1,9%*A1-3000,12%*A1-6750,13%*A1-8250)
HTH. :) -- Dana DeLouis Win XP & Office 2003 "jewels" wrote in message ... I am trying to make the following formula work and am going nuts trying to make it work - I even called Microsoft and they couldn't do it either? Here is what I am trying to do. I want say cell A1 (this will be the variable) from 0 to 100,000 multiply by 6% from 100,000 to 125,0000 multiply by 9% from 125,000 to 150,0000 multilpy by 12% from 150,000 and up multiply by 13% so if A1 was 175,000, the first 100,000 is at 6% (6,000) the next 25,000 is at 9% (2,250) the next 25,000 is at 12% (3,000) the next 25,000 is at 13% (3,250) the total would be $14,500. This is a bonus calculation so A1 is the revenue that bonus is calculated. Does anyone have any ideas! I would be forever grateful! Thanks Jewels |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
formula I can't figure it out?! ARGH
Hi Dana
Very neat!! Regards Roger Govier Dana DeLouis wrote: =MAX(6%*A1,9%*A1-3000,12%*A1-6750,13%*A1-8250) HTH. :) |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
formula I can't figure it out?! ARGH
THANK YOU THANK YOU THANK YOU
"jewels" wrote: I am trying to make the following formula work and am going nuts trying to make it work - I even called Microsoft and they couldn't do it either? Here is what I am trying to do. I want say cell A1 (this will be the variable) from 0 to 100,000 multiply by 6% from 100,000 to 125,0000 multiply by 9% from 125,000 to 150,0000 multilpy by 12% from 150,000 and up multiply by 13% so if A1 was 175,000, the first 100,000 is at 6% (6,000) the next 25,000 is at 9% (2,250) the next 25,000 is at 12% (3,000) the next 25,000 is at 13% (3,250) the total would be $14,500. This is a bonus calculation so A1 is the revenue that bonus is calculated. Does anyone have any ideas! I would be forever grateful! Thanks Jewels |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formula to give 5%rise in a figure if it occurs b/wn 2 dates | Excel Worksheet Functions | |||
Formula checking multiple worksheets | Excel Worksheet Functions | |||
Formula checking multiple worksheets | Excel Worksheet Functions | |||
Match / Vlookup within an Array formula | Excel Discussion (Misc queries) | |||
How do figure excel formula out? | Excel Discussion (Misc queries) |