Sum funtion to substract

Closed
jutulu Posts 34 Registration date Monday 10 March 2014 Status Member Last seen 21 September 2015 - 21 Sep 2015 à 19:55
Mazzaropi Posts 1983 Registration date Monday 16 August 2010 Status Contributor Last seen 24 May 2023 - 21 Sep 2015 à 20:30
Hello,

When I do the below formula the results are different. What's the difference between Sum function and simply doing the subtraction directly? Sum is also used for subtractions, correct? What is the main use for sum?


£121,821.05 SUM (E73-E72-G69)
£118,597.05 E72-E73-G69

1 response

Mazzaropi Posts 1983 Registration date Monday 16 August 2010 Status Contributor Last seen 24 May 2023 147
21 Sep 2015 à 20:30
jutulu, Good evening.

You're right.
Either way the result MUST be the same.
No mysteries.

=SUM(A1-A2-A3)

It has the same result:

=A1-A2-A3

Looking to your formulas we can see a little mistake.
Is it this error that is affecting its result?
-------------------------------------
£121,821.05 SUM (E73-E72-G69)
£118,597.05 E72-E73-G69

SUM(E73-E72-G69)
.......E72-E73-G69

E72 and E73 have differents signals!!
-------------------------------------

is that what you looking for?
I hope I've helped.
--
Belo Horizonte, Brasil.
Marcílio Lobão