Percentage Formula

[yvonneb]

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 figure:

B13*0.275x(0.015/12)

Does this make sense? Any help will be much appreciatd. Thx.

 

[muddan madhu]

try this

=((B13*1.5%)/12*(27.5%))*40%

 

[Fred Smith]

You forgot the subtraction part. Try it this way:

=B13*1.5%/12*(1-27.5%)*(1-40%)

Regards,
Fred.

 

[Mike H]

Try,

=(((B13*1.5%)/12)*27.5%)*40%

Mike

 

[Fred Smith]

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.

 

[yvonneb]

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]

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.