Percentage Formula
Hi. I have a figure (B13) which I need to find 1.5% of, divide this by 12
months, then subtract 27.5% then subtract 40% to give me a final figure. $1,066,946.81 * 1.5% / 12 * 27.50% * 40% I have the following but don't know where to put in the 40% in order to obtain the final figu B13*0.275x(0.015/12) Does this make sense? Any help will be much appreciatd. Thx. |
Percentage Formula
try this
=((B13*1.5%)/12*(27.5%))*40% On Sep 28, 6:11*pm, yvonneb wrote: Hi. I have a figure (B13) which I need to find 1.5% of, divide this by 12 months, then subtract 27.5% then subtract 40% to give me a final figure. $1,066,946.81 * 1.5% / 12 * 27.50% * 40% I have the following but don't know where to put in the 40% in order to obtain the final figu B13*0.275x(0.015/12) Does this make sense? *Any help will be much appreciatd. *Thx. |
Percentage Formula
You forgot the subtraction part. Try it this way:
=B13*1.5%/12*(1-27.5%)*(1-40%) Regards, Fred. "yvonneb" wrote in message ... Hi. I have a figure (B13) which I need to find 1.5% of, divide this by 12 months, then subtract 27.5% then subtract 40% to give me a final figure. $1,066,946.81 * 1.5% / 12 * 27.50% * 40% I have the following but don't know where to put in the 40% in order to obtain the final figu B13*0.275x(0.015/12) Does this make sense? Any help will be much appreciatd. Thx. |
Percentage Formula
Try,
=(((B13*1.5%)/12)*27.5%)*40% Mike "yvonneb" wrote: Hi. I have a figure (B13) which I need to find 1.5% of, divide this by 12 months, then subtract 27.5% then subtract 40% to give me a final figure. $1,066,946.81 * 1.5% / 12 * 27.50% * 40% I have the following but don't know where to put in the 40% in order to obtain the final figu B13*0.275x(0.015/12) Does this make sense? Any help will be much appreciatd. Thx. |
Percentage Formula
As multiplication and division have the same priority, the parentheses have
no effect. The two formulas: =(((B13*1.5%)/12)*27.5%)*40% and =B13*1.5%/12*27.5%*40% produce exactly the same result. However, neither of these formulas *subtract* 27.5% or 40%. Regards, Fred. "Mike H" wrote in message ... Try, =(((B13*1.5%)/12)*27.5%)*40% Mike "yvonneb" wrote: Hi. I have a figure (B13) which I need to find 1.5% of, divide this by 12 months, then subtract 27.5% then subtract 40% to give me a final figure. $1,066,946.81 * 1.5% / 12 * 27.50% * 40% I have the following but don't know where to put in the 40% in order to obtain the final figu B13*0.275x(0.015/12) Does this make sense? Any help will be much appreciatd. Thx. |
Percentage Formula
Thanks everyone who replied. I get the gist of it, but it still doesn't give
me the correct final figure. If I do it manually it goes like this: Total Value: 1,066,946.81 x 1.5%: 16,004.20 Divided by 12: 1,333.68 Less 27.5%: 366.76 Equals: 966.92 x 40%: 386.76 It's the $386.76 figure I'm trying to get to. Your formula Fred gives me a final figure 580.15; is the above possible in one formula? Many thanks. "Fred Smith" wrote: You forgot the subtraction part. Try it this way: =B13*1.5%/12*(1-27.5%)*(1-40%) Regards, Fred. "yvonneb" wrote in message ... Hi. I have a figure (B13) which I need to find 1.5% of, divide this by 12 months, then subtract 27.5% then subtract 40% to give me a final figure. $1,066,946.81 * 1.5% / 12 * 27.50% * 40% I have the following but don't know where to put in the 40% in order to obtain the final figu B13*0.275x(0.015/12) Does this make sense? Any help will be much appreciatd. Thx. |
Percentage Formula
Yes, it's possible. All we have to know is what you want to do. And, as
always, examples at the start save everyone a lot of time. In your case, you initially said for the last step, you wanted to "subtract 40%". Now you say you want 40% of the resulting balance. So use: =B13*1.5%/12*(1-27.5%)*40% Regards, Fred. "yvonneb" wrote in message ... Thanks everyone who replied. I get the gist of it, but it still doesn't give me the correct final figure. If I do it manually it goes like this: Total Value: 1,066,946.81 x 1.5%: 16,004.20 Divided by 12: 1,333.68 Less 27.5%: 366.76 Equals: 966.92 x 40%: 386.76 It's the $386.76 figure I'm trying to get to. Your formula Fred gives me a final figure 580.15; is the above possible in one formula? Many thanks. "Fred Smith" wrote: You forgot the subtraction part. Try it this way: =B13*1.5%/12*(1-27.5%)*(1-40%) Regards, Fred. "yvonneb" wrote in message ... Hi. I have a figure (B13) which I need to find 1.5% of, divide this by 12 months, then subtract 27.5% then subtract 40% to give me a final figure. $1,066,946.81 * 1.5% / 12 * 27.50% * 40% I have the following but don't know where to put in the 40% in order to obtain the final figu B13*0.275x(0.015/12) Does this make sense? Any help will be much appreciatd. Thx. |
All times are GMT +1. The time now is 01:06 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com