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

On 10/9/24 00:49, Sharon Kimble wrote:
> 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?

The D17 > D18 cell reference will automatically increment when dragged down.

My solution to get a decrementing number is to utilize a separate
column, with a formula.  For example, enter 75 in cell E1, then formula
'=E1-1' in cell E2.  Dragging cell E2 downward will produce a
decrementing number, which can then be referenced from the original
formula:  '=SUM(D18/E18)', which will enable dragging downward to
auto-fill with correct references.  Column E (or whatever you use) can
be hidden if desired.

FYI:  SUM function is unnecessary in this formula, '=D18/E18' should
produce same results.


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