Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
IF FACTOR?
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% |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Growth Factor | Excel Discussion (Misc queries) | |||
multiply all values in all cells by a factor | Excel Discussion (Misc queries) | |||
how do i set up a weighted factor model in excel? | Excel Worksheet Functions | |||
How to make "common factor" formula ? | Excel Worksheet Functions | |||
Formula pull factor from chart based on value of diff field? | Excel Worksheet Functions |