Re: [libreoffice-users] Updating Data in Calc

At 15:01 13/06/2021 +0200, Hylton Conacher wrote:
> A simple sum will do it i.e.: In cell Y4 insert [...]
> =SUM(M18-$W$4)

I'm often puzzled by suggestions such as this. In what way do you 
think that =SUM(Xm-Yn) differs from =Xm-Yn? The minus sign effects 
the subtraction between two values, generating a single value as its 
result. You then pass this single value to the SUM() function. What 
do you expect that function do with a single value? The sum of two 
and two is four; what do you think is the sum of just two?

Brian Barker  


--
To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
Privacy Policy: https://www.documentfoundation.org/privacy