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.

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.

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.

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.

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.

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.

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.