For a one-off column of decrementing numbers, it also works to put say, 76 in the first row, 75 in the next row. Then select both cells before dragging down on the auto-fill tab.
-- Tim Hoover -- On Wed, 9 Oct 2024 06:47:38 -0400, Java Joe wrote: > 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: [email protected] > 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 > > -- To unsubscribe e-mail to: [email protected] 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
