software

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 amp; 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

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

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

quot;JaBquot; gt; wrote in message
news
gt; Hi
gt;
gt; Im sure theres a simple answer to this but Im having problems with a
formula.
gt;
gt; My formula is as follows -
gt;
gt; =(D33 E33)-(S33 T33)/(D33 E33)
gt;
gt; Essentially the sum of D33 amp; E33 is 19, the sum of S33 T33 is 7 giving me
gt; 12. This is divided by the intial 19 so I am expecting to see an answer
of
gt; 0.6315 which I planned to turn into a percentage. The formula above,
gt; however, returns 18.6315, but I dont know why. Clearly there is a problem
gt; with the formula, and its probably staring me in the face but I cant see
it!!!
gt;
gt; Can anyone suggest anything?
gt;
gt; Cheers
Hi,

You have to add 19 7 befor you divide with 19

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

Regards,
BondiOperator 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
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)JaB Wrote:
gt; Hi
gt;
gt; Im sure theres a simple answer to this but Im having problems with a
gt; formula.
gt;
gt; My formula is as follows -
gt;
gt; =(D33 E33)-(S33 T33)/(D33 E33)
gt;
gt; Essentially the sum of D33 amp; E33 is 19, the sum of S33 T33 is 7 giving
gt; me
gt; 12. This is divided by the intial 19 so I am expecting to see an
gt; answer of
gt; 0.6315 which I planned to turn into a percentage. The formula above,
gt; however, returns 18.6315, but I dont know why. Clearly there is a
gt; problem
gt; with the formula, and its probably staring me in the face but I cant
gt; see it!!!
gt;
gt; Can anyone suggest anything?
gt;
gt; Cheers--
John James
------------------------------------------------------------------------
John James's Profile: www.excelforum.com/member.php...oamp;userid=32690
View this thread: www.excelforum.com/showthread...hreadid=534115gt; =(D33 E33)-(S33 T33)/(D33 E33)

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

--
HTH. :gt;)
Dana DeLouis
Windows XP, Office 2003quot;JaBquot; gt; wrote in message
news
gt; Hi
gt;
gt; Im sure theres a simple answer to this but Im having problems with a
gt; formula.
gt;
gt; My formula is as follows -
gt;
gt; =(D33 E33)-(S33 T33)/(D33 E33)
gt;
gt; Essentially the sum of D33 amp; E33 is 19, the sum of S33 T33 is 7 giving me
gt; 12. This is divided by the intial 19 so I am expecting to see an answer
gt; of
gt; 0.6315 which I planned to turn into a percentage. The formula above,
gt; however, returns 18.6315, but I dont know why. Clearly there is a problem
gt; with the formula, and its probably staring me in the face but I cant see
gt; it!!!
gt;
gt; Can anyone suggest anything?
gt;
gt; Cheers
BEDMAS:
brackets
exponents
div/mult
add/sub

Kevin M

quot;JaBquot; wrote:

gt; Hi
gt;
gt; Im sure theres a simple answer to this but Im having problems with a formula.
gt;
gt; My formula is as follows -
gt;
gt; =(D33 E33)-(S33 T33)/(D33 E33)
gt;
gt; Essentially the sum of D33 amp; E33 is 19, the sum of S33 T33 is 7 giving me
gt; 12. This is divided by the intial 19 so I am expecting to see an answer of
gt; 0.6315 which I planned to turn into a percentage. The formula above,
gt; however, returns 18.6315, but I dont know why. Clearly there is a problem
gt; with the formula, and its probably staring me in the face but I cant see it!!!
gt;
gt; Can anyone suggest anything?
gt;
gt; Cheers

BODMAS at my school :-)

Brackets, Order, etc;

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

quot;Kevin Mquot; gt; wrote in message
...
gt; BEDMAS:
gt; brackets
gt; exponents
gt; div/mult
gt; add/sub
gt;
gt; Kevin M
gt;
gt; quot;JaBquot; wrote:
gt;
gt; gt; Hi
gt; gt;
gt; gt; Im sure theres a simple answer to this but Im having problems with a
formula.
gt; gt;
gt; gt; My formula is as follows -
gt; gt;
gt; gt; =(D33 E33)-(S33 T33)/(D33 E33)
gt; gt;
gt; gt; Essentially the sum of D33 amp; E33 is 19, the sum of S33 T33 is 7 giving
me
gt; gt; 12. This is divided by the intial 19 so I am expecting to see an answer
of
gt; gt; 0.6315 which I planned to turn into a percentage. The formula above,
gt; gt; however, returns 18.6315, but I dont know why. Clearly there is a
problem
gt; gt; with the formula, and its probably staring me in the face but I cant see
it!!!
gt; gt;
gt; gt; Can anyone suggest anything?
gt; gt;
gt; gt; Cheers