Date: prev next · Thread: first prev next last
2021 Archives by date, by thread · List index

Hi Vince,

On 2021/06/12 17:20, Vince@Verizon wrote:

Using LO vers (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 "


In cell Y5


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

To unsubscribe e-mail to:
Posting guidelines + more:
List archive:
Privacy Policy:


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.