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.
|