View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Fred Smith[_4_] Fred Smith[_4_] is offline
external usenet poster
 
Posts: 2,389
Default 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.