LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
JaB
 
Posts: n/a
Default 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
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On



All times are GMT +1. The time now is 05:33 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"