Re: [libreoffice-users] auto-populating cells with one figure increasing, and the second figure decreasing, but how, please?

Hello,

If your list is in a column, you can use the ROW() function to figure
out on which line you are. For example, if the first entry is in cell
B2:

Formula in cell B2: =sum(D2/(90-row()+row($b$2))

If you now drag this to cell B3, the formula will be converted to
=sum(D3/(90-row()+row($b$2))

ROW() without arguments gives you the row number of the cell, while
placing a cell reference gives you the row of that cell. You will
notice that I used "$b$2": doing this tells Calc that if you drag or
copy the cell containing the formula, the reference cannot be changed.

By the way, I am not sure I understand your usage of SUM() in the
formula you provided. Unless I am missing something, D17/76 and
sum(D17/76) should yield the same answer.

I hope this helps.

Best regards,
Rémy.


Le mercredi 09 octobre 2024 à 05:49 +0100, Sharon Kimble a écrit :
> I'm trying to construct a spreadsheet which will track my writing
> goals for a 90-day period and is of this format '=SUM(D17/76)' and
> the cell beneath it is '=SUM(D18/75)'.
>
> So how can I get it such that the first figure is increasing, and the
> second figure is decreasing, and I can just drag the cells downwards
> and it auto-populates the cells as I'm trying to get them, please? Or
> in other words, at the
>   end of the 90-day period the second figure will be zero, please?
>
> Thanks
>   Sharon.


-- 
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