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 spreadsheets, of
``course. If you change the values in cells that are referenced in
``formulae elsewhere, the result of those formulae will immediately change.
`
At 11:46 13/06/2021 -0400, Vince Bonly wrote:

`Perhaps I should have written in my OP that "The formula /presently/
``in $Y$4=$M18-$W$4". I expect that that formula, obviously, must be
``changed to reach a solution to my problem, ...
`

`That formula was the only hint anyone had as to what you are trying
``to achieve. If, as you now say, it does not define your need, there
``is absolutely no indication so far in what you have given for anyone
``to go on. You are seeking a solution to a problem you have not been
``prepared to state. If you put some formula in Y4 (in this context it
``makes no sense to call it "$Y$4") that depends on (some? all of the?)
``values in column M, its result will change when those source values change.
`
Whether you need
=SUM(M1:M99)
or
=MAX(M1:M99)
or
=VLOOKUP(M4,X1:Y10,2,FALSE)
or
=IF(SUM(M1:M99)>0,"Hooray: I'm solvent!","Shucks, I'm bankrupt.")
or one of a thousand other possibilities we can only guess.
I trust this helps.
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

### Context

Privacy Policy |

Impressum (Legal Info) |

*Copyright information*: Unless otherwise specified, all text and images
on this website are licensed under the

Creative Commons Attribution-Share Alike 3.0 License.
This does not include the source code of LibreOffice, which is
licensed under the Mozilla Public License (

MPLv2).
"LibreOffice" and "The Document Foundation" are
registered trademarks of their corresponding registered owners or are
in actual use as trademarks in one or more countries. Their respective
logos and icons are also subject to international copyright laws. Use
thereof is explained in our

trademark policy.