| 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 |
| 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) | |||
Threaded Mode
