Sum funtion to substract

Closed
jutulu Posts 34 Registration date Monday March 10, 2014 Status Member Last seen September 21, 2015 - Sep 21, 2015 at 07:55 PM
Mazzaropi Posts 1985 Registration date Monday August 16, 2010 Status Contributor Last seen May 24, 2023 - Sep 21, 2015 at 08:30 PM
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 1985 Registration date Monday August 16, 2010 Status Contributor Last seen May 24, 2023 147
Sep 21, 2015 at 08:30 PM
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
0