View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Mike H Mike H is offline
external usenet poster
 
Posts: 11,501
Default Percentage Formula

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.