Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sum and Divide Formula error
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sum and Divide Formula error
Hi,
You have to add 19+7 befor you divide with 19 =((D33+E33)-(S33+T33))/(D33+E33) Regards, Bondi |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sum and Divide Formula error
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 |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sum and Divide Formula error
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: 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 -- John James ------------------------------------------------------------------------ John James's Profile: http://www.excelforum.com/member.php...o&userid=32690 View this thread: http://www.excelforum.com/showthread...hreadid=534115 |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sum and Divide Formula error
=(D33+E33)-(S33+T33)/(D33+E33)
Not sure if this would be of interest: =1-(S33+T33)/(D33+E33) -- HTH. :) Dana DeLouis Windows XP, Office 2003 "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 |
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sum and Divide Formula error
BEDMAS:
brackets exponents div/mult add/sub Kevin M "JaB" wrote: 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 |
#8
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sum and Divide Formula error
BODMAS at my school :-)
Brackets, Order, etc; -- HTH Bob Phillips (remove nothere from email address if mailing direct) "Kevin M" wrote in message ... BEDMAS: brackets exponents div/mult add/sub Kevin M "JaB" wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|