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