Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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 |