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:

[hidden email]
For additional commands, e-mail:

[hidden email]