"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.
Attachments
ex1.ods
Simple example
(8.85 KiB) Downloaded 13 times
OpenOffice 3.1.0 on Debian 7
j4nd3r53n
 
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
RoryOF
Moderator
 
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
=A4*$G$2

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.
FJCC
Moderator
 
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