Formula for Gross Profit % to commission % based on GP $

[Antveenie]

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

 

[pmartglass]

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 ?

 

[pmartglass]

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