"Constants" in a spreadsheet

Discuss the spreadsheet application

"Constants" in a spreadsheet

Postby j4nd3r53n » Wed Feb 19, 2020 3:39 pm

Sometimes I need to divide/multiply a column of numbers with the same value, which in turn is calculated from numbers in other cells. It would be handy if I could first calculate that value somewhere in the sheet, and then reference it in a column - however, if I just reference the calculated cell in the first cell of the column of my calculations, then copy the it to the next cells, the reference "moves", as designed - see the attached, simple example.

Is there a way to avoid that? I think it must be something that many would find useful.
Simple example
(8.85 KiB) Downloaded 13 times
OpenOffice 3.1.0 on Debian 7
Posts: 5
Joined: Mon Nov 25, 2013 10:50 pm

Re: "Constants" in a spreadsheet

Postby RoryOF » Wed Feb 19, 2020 3:46 pm

You might find [Tutorial] Absolute, relative and mixed references a useful resource.
Apache OpenOffice 4.1.7 on Xubuntu 20.04.1 (mostly 64 bit version) and very infrequently on Win2K/XP
User avatar
Posts: 31429
Joined: Sat Jan 31, 2009 9:30 pm
Location: Ireland

Re: "Constants" in a spreadsheet

Postby FJCC » Wed Feb 19, 2020 4:32 pm

In this specific case, make the formula in B4
Code: Select all   Expand viewCollapse view

and then copy it down.
Windows 10 and Linux Mint, since 2017
If your question is answered, please go to your first post, select the Edit button, and add [Solved] to the beginning of the title.
Posts: 7750
Joined: Sat Nov 08, 2008 8:08 pm
Location: Colorado, USA

Return to Calc

Who is online

Users browsing this forum: No registered users and 18 guests