Sum and Divide Formula error
=((D33+E33)-(S33+T33))/(D33+E33)
--
HTH
Bob Phillips
(remove nothere from email address if mailing direct)
"JaB" wrote in message
...
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
|