Re: [libreoffice-users] Updating Data in Calc

2021-06-15 Thread Hylton Conacher (ZR1HPC)
On 2021/06/15 11:28, Dave Howorth wrote: On Mon, 14 Jun 2021 21:35:49 +0200 "Hylton Conacher (ZR1HPC)" wrote: It has often puzzled me why when knowledgeable members of mailing lists such as this, find fault in what someone, less qualified than themselves, suggests. It is not taken via private

Re: [libreoffice-users] Updating Data in Calc

2021-06-15 Thread Dave Howorth
On Mon, 14 Jun 2021 21:35:49 +0200 "Hylton Conacher (ZR1HPC)" wrote: > It has often puzzled me why when knowledgeable members of mailing > lists such as this, find fault in what someone, less qualified than > themselves, suggests. It is not taken via private mail but splashed > on the mailing

Re: [libreoffice-users] Updating Data in Calc

2021-06-14 Thread Hylton Conacher (ZR1HPC)
Dear Brian, On 2021/06/13 18:52, Brian Barker wrote: 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

Re: [libreoffice-users] Updating Data in Calc

2021-06-13 Thread Brian Barker
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,

Re: [libreoffice-users] Updating Data in Calc

2021-06-13 Thread Brian Barker
At 11:20 12/06/2021 -0400, Vince Bonly wrote: I would greatly receiving an explanation of a formula or function in Calc that updates the data within cell $Y$4 each time the data in column [M] changes. The formula in $Y$4 =$M18-$W$4. Generally speaking, this process is automatic in

Re: [libreoffice-users] Updating Data in Calc

2021-06-13 Thread Vince@Verizon
Hi Hylton: Thank you, OM, for giving this problem some thought; I do appreciate your suggestion/comments. I understand your approach in your suggested solution; however, it does not satisfy my requirements. The numerical data that is entered, or calculated in this situation, within the rows

Re: [libreoffice-users] Updating Data in Calc

2021-06-13 Thread Hylton Conacher (ZR1HPC)
Hi Vince, On 2021/06/12 17:20, Vince@Verizon wrote: Hello: Using LO vers 7.1.3.2 (x64) on desktop Windows 10 Home (64-bit). I would greatly receiving an explanation of a formula or function in Calc that updates the data within cell $Y$4 each time the data in column [M] changes.  The formula

[libreoffice-users] Updating Data in Calc

2021-06-12 Thread Vince@Verizon
Hello: Using LO vers 7.1.3.2 (x64) on desktop Windows 10 Home (64-bit). I would greatly receiving an explanation of a formula or function in Calc that updates the data within cell $Y$4 each time the data in column [M] changes.  The formula in $Y$4 =$M18-$W$4. [M]