LinuxQuestions.org
Visit Jeremy's Blog.
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Software
User Name
Password
Linux - Software This forum is for Software issues.
Having a problem installing a new program? Want to know which application is best for the job? Post your question in this forum.

Notices


Reply
  Search this Thread
Old 09-16-2014, 09:13 PM   #1
timl
Member
 
Registered: Jan 2009
Location: Sydney, Australia
Distribution: Fedora,CentOS
Posts: 746

Rep: Reputation: 156Reputation: 156
LibreOffice calc quick question


Hi, I think I am missing something obvious here so any advice appreciated.

I have a spreadsheet to calculate weekly earnings based on a single hourly rate.

For the sake of an example let's say the hourly rate is in cell L2. The daily hours are in column D and the earnings per day are calculated in column F.

So
Quote:
F4 = D4 * L2
F5 = D5 * L2
F6 = D6 * L2
and so on.

I would like to drag the F column down rather than typing in the formula every time. This increments the "D" column correctly but it also increments the "L" column which destroys the formula.

Is there a simple method of copying a formula, changing one variable but not another?

Cheers
 
Old 09-16-2014, 09:26 PM   #2
frankbell
LQ Guru
 
Registered: Jan 2006
Location: Virginia, USA
Distribution: Slackware, Ubuntu MATE, Mageia, and whatever VMs I happen to be playing with
Posts: 19,219
Blog Entries: 28

Rep: Reputation: 6114Reputation: 6114Reputation: 6114Reputation: 6114Reputation: 6114Reputation: 6114Reputation: 6114Reputation: 6114Reputation: 6114Reputation: 6114Reputation: 6114
When you create a formula, a little black square will appear to the bottom right of the "sum" cell.

Left-click and hold on that little black square and drag the mouse down. Cells will be highlighted and the formula will be replicated with appropriate values as you drag the mouse down.

Last edited by frankbell; 09-16-2014 at 09:27 PM.
 
Old 09-16-2014, 09:34 PM   #3
timl
Member
 
Registered: Jan 2009
Location: Sydney, Australia
Distribution: Fedora,CentOS
Posts: 746

Original Poster
Rep: Reputation: 156Reputation: 156
thanks.

Unfortunately this changes both variables in the equation. I do not want the second variable to change.

Cheers
 
Old 09-16-2014, 09:38 PM   #4
frankbell
LQ Guru
 
Registered: Jan 2006
Location: Virginia, USA
Distribution: Slackware, Ubuntu MATE, Mageia, and whatever VMs I happen to be playing with
Posts: 19,219
Blog Entries: 28

Rep: Reputation: 6114Reputation: 6114Reputation: 6114Reputation: 6114Reputation: 6114Reputation: 6114Reputation: 6114Reputation: 6114Reputation: 6114Reputation: 6114Reputation: 6114
Drat. Sorry.

I have to work on my reading comprehension.

Last edited by frankbell; 09-16-2014 at 09:44 PM.
 
Old 09-17-2014, 05:42 AM   #5
salasi
Senior Member
 
Registered: Jul 2007
Location: Directly above centre of the earth, UK
Distribution: SuSE, plus some hopping
Posts: 4,070

Rep: Reputation: 897Reputation: 897Reputation: 897Reputation: 897Reputation: 897Reputation: 897Reputation: 897
I'm not sure that I have understood your question correctly (and this dragging method is not one that I would use), but, if, instead of 'L2' you use '$L$2', doesn't that do it?
 
1 members found this post helpful.
Old 09-17-2014, 06:37 AM   #6
timl
Member
 
Registered: Jan 2009
Location: Sydney, Australia
Distribution: Fedora,CentOS
Posts: 746

Original Poster
Rep: Reputation: 156Reputation: 156
that is it. Many thanks

AAMOI though...any other recommendations?
 
  


Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off



Similar Threads
Thread Thread Starter Forum Replies Last Post
Absolute value of a column in Libreoffice calc Adwat Linux - Software 5 07-31-2021 04:30 PM
protect/lock a cell in libreoffice calc knobby67 Linux - Software 5 01-11-2015 05:45 AM
[SOLVED] Formula Locking In LibreOffice Calc cin_ Linux - Software 2 11-19-2012 06:12 AM
[SOLVED] libreoffice calc qrange Linux - Software 2 09-13-2012 02:19 AM
Libreoffice Calc - Hyperlink Problems Myrlin Linux - Desktop 6 11-04-2011 07:16 AM

LinuxQuestions.org > Forums > Linux Forums > Linux - Software

All times are GMT -5. The time now is 04:34 AM.

Main Menu
Advertisement
My LQ
Write for LQ
LinuxQuestions.org is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
Syndicate
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
Open Source Consulting | Domain Registration