Thread: 1000-200*4% add
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Roger Govier Roger Govier is offline
external usenet poster
 
Posts: 2,886
Default 1000-200*4% add

Hi

As you have written the formula in your subject line, the answer will be
992, since multiplication takes precedence over subtraction.
i.e 1000-(200*4%) = 1000-(8) =992

I suspect that what you are really wanting, is to add 4% to the value
obtained after subtracting 800 from 1000 i.e.
(1000-200) = 800, 800*4% =32, 800+32 = 832
if so then use
(1000-200)*(1+4%)

Without the inclusion of the 1 within the second set of parentheses, you
would just get the result of 32, i.e 800*4%
The addition of the 1, is the same as multiply the answer by 104%, in
other words raise the value by 4%
--
Regards

Roger Govier


"deepak" wrote in message
...
pls give me answer of this quetion.

a b c
1000 - 200 A-b+4%add