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: [email protected] 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
