How would I create a formula to do the following:
I need to multiply figure A by the correct % based on the figures in B and C
A)$177,740 B) 38.3% C) 41.79
Ex- If B is 38.3% I would need to us the % rate based on GM% less than 40,
however,because C is 41.79 that is greater than 40 so the multiplier would
be 6.0%
The end result I would need is $177,740 X 6%. To get the 6% figure I need to
determine by the charte below, what % to use.
(B) ********(C)*********
GM% 20 20-40 40
<35 3.0% 3.5% 4.0%
<40 4.0% 5.0% 6.0%
<45 5.0% 7.0% 9.0%
<50 6.0% 9.0% 12.0%