1000-200*4% add

  • Thread starter Thread starter Guest
  • Start date Start date
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%
 
You haven't made it clear what you want.
Perhaps one of the following? [I have included parentheses to make it clear
to you what the priority of the arithmetic operations will be, but in some
cases the parentheses can be omitted because of the defined precedence of
the operators.]

=A1-(B1*4%)
=(A1-B1)*4%
=A1-(B1+(B1*4%)) or =A1-(B1*(1+4%))
=(A1-B1)*(1+4%)
 
Back
Top