Sum funtion to substract

Closed
Report
Posts
34
Registration date
Monday March 10, 2014
Status
Member
Last seen
September 21, 2015
-
Posts
1947
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
November 11, 2021
-
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 reply

Posts
1947
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
November 11, 2021
147
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