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
|