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.