Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formula for Gross Profit % to commission % based on GP $
I need an formula that will use the GP % in col. E then put the answer in
col. G, I, or K depending on the percent in col. E, using the % rate of comission paid for corresponding GP comission rate times the total weekly sales in col. M to calculate weekly bonus pay. Example: Col E Col G Col I Col K Col M GP % 49%=1.35% 52%=1.55% 54%=1.85% Weekly $ 49% $217.48 $16,109.68 52% $250.84 $16183.30 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formula for Gross Profit % to commission % based on GP $
Is it possible for you to split the information across row 1 into two cells
example 1 cell contains the 49% and the other cell contains 1.35% this would make for a much simpler formula and more flexibility if you need to change either percentage in the future ? "Antveenie" wrote: I need an formula that will use the GP % in col. E then put the answer in col. G, I, or K depending on the percent in col. E, using the % rate of comission paid for corresponding GP comission rate times the total weekly sales in col. M to calculate weekly bonus pay. Example: Col E Col G Col I Col K Col M GP % 49%=1.35% 52%=1.55% 54%=1.85% Weekly $ 49% $217.48 $16,109.68 52% $250.84 $16183.30 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formula for Gross Profit % to commission % based on GP $
If you can't split thr Gross Profit line into 2 lines one way would be to use
this formula =IF((LEFT(F$302,(LEN($E303)-1))*1=$E303),(MID(F$302,(LEN($E303)+1),(LEN(F$302)-LEN($E303)+1)))*$I303,"") excel will read your gross profit line as text and your percentage as a number so you need to convert the result so that it is comparing like formats Hope this helps "Antveenie" wrote: I need an formula that will use the GP % in col. E then put the answer in col. G, I, or K depending on the percent in col. E, using the % rate of comission paid for corresponding GP comission rate times the total weekly sales in col. M to calculate weekly bonus pay. Example: Col E Col G Col I Col K Col M GP % 49%=1.35% 52%=1.55% 54%=1.85% Weekly $ 49% $217.48 $16,109.68 52% $250.84 $16183.30 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
future value and gross profit. | Excel Discussion (Misc queries) | |||
gross profit | Excel Worksheet Functions | |||
how to work out gross profit on items | Excel Discussion (Misc queries) | |||
Calculate gross profit based on varying percentages | Excel Worksheet Functions | |||
gross profit margin formula | Excel Discussion (Misc queries) |