View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
muddan madhu muddan madhu is offline
external usenet poster
 
Posts: 747
Default Percentage Formula

try this

=((B13*1.5%)/12*(27.5%))*40%



On Sep 28, 6:11*pm, 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.