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 in $Y$4 =$M18-$W$4.
[M] [Y]
Row 18 ----------------------> Row 4
Row 19 ----------------------> Row 4
Row 20 ----------------------> Row 4
Row 21 ----------------------> Row 4
Row 21 ----------------------> Row 4
Where is column W in your layout? The below is done on assumption.
A simple sum will do it i.e.:
In cell Y4 insert everything between the "
"=SUM(M18-$W$4)"
In cell Y5
"=SUM(M19-$W$4)"
In theory you could just drag the formula from cell Y4 down to the
bottom and then just change those M reference cell numbers.
Remember that putting a $ before either a letter or number reference of
a cell LOCKS that formula i.e. dragging the formula down a column to
populate cells below will keep whatever is prefixed with $.
Hope it helps
Hylton
--
To unsubscribe e-mail to: users+unsubscr...@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
