Re: how do a display a sum in Calc?

[Brian Barker <b....@btinternet.com.INVALID>]

At 12:25 30/10/2018 -0500, Wade Smart wrote:
>=sum(a1+b1)

Since you chose to broadcast this to the masses, it is perhaps worth 
saying that it is somewhat amusing overkill.
o Why not =SUM(A1)+SUM(B1) or =SUM(SUM(A1+B1))?
o Would you multiply using =PRODUCT(A1*B1) or =SUM(PRODUCT(A1*B1))?
(All of these work!)

=SUM(A1+B1) adds the two values together - using the "+" operator - 
and then passes the result to the SUM() function to add it to - oh, 
er, nothing else.

No: instead, only EITHER
=A1+B1
OR
=SUM(A1,B1)
makes sense.

Brian Barker  


---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@openoffice.apache.org
For additional commands, e-mail: users-help@openoffice.apache.org