Sum and Divide Formula error

[Guest]

Hi

Im sure theres a simple answer to this but Im having problems with a formula.

My formula is as follows -

=(D33+E33)-(S33+T33)/(D33+E33)

Essentially the sum of D33 & E33 is 19, the sum of S33+T33 is 7 giving me
12. This is divided by the intial 19 so I am expecting to see an answer of
0.6315 which I planned to turn into a percentage. The formula above,
however, returns 18.6315, but I dont know why. Clearly there is a problem
with the formula, and its probably staring me in the face but I cant see it!!!

Can anyone suggest anything?

Cheers

 

[Bob Phillips]

=((D33+E33)-(S33+T33))/(D33+E33)

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

 

[Bondi]

Hi,

You have to add 19+7 befor you divide with 19

=((D33+E33)-(S33+T33))/(D33+E33)

Regards,
Bondi

 

[chillihawk]

Operator precedence. Excel evaluates the division operator before the
subtraction operator. So the total operation is really 19 - (7/19).
Wrap brackets around the part you want evaluated first. Something
like: =((D33+E33)-(S33+T33))/(D33+E33). HTH

 

[John James]

Your formula equates to 19 minus 7/19, not 19 minus 7 (=12) divided by
19.
To get the formula you want put an open bracket after the equals sign
and another close bracket before the / sign. This keep the 19 and the
7 together before the division.
=((D33+E33)-(S33+T33))/(D33+E33)

 

[Dana DeLouis]

=(D33+E33)-(S33+T33)/(D33+E33)

Not sure if this would be of interest:
=1-(S33+T33)/(D33+E33)

 

[Guest]

BEDMAS:
brackets
exponents
div/mult
add/sub

Kevin M

 

[Bob Phillips]

BODMAS at my school

Brackets, Order, etc;

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)