View Single Post
  #3   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

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.