Re: [libreoffice-users] Updating Data in Calc

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