[Solved] copying formulas

Discuss the spreadsheet application

[Solved] copying formulas

Postby harfis01 » Fri May 18, 2018 5:35 pm

I am wanting to copy a formula but leave one of the cell references the same.

The specific formula I am working with is....=LCM(C1,A3)/A3.....with the C being the column and A being the row.

I want to copy the formula down a row but leave the column reference the same, and the same for going across.
Here is how I want the spreadsheet to look with the first cell reference (C1, D1, E1, etc) being the columns and the second cell reference (A3, A4, A5, etc) being the rows.

Code: Select all   Expand viewCollapse view
=LCM(C1,A3)/A3     =LCM(D1,A3)/A3     =LCM(E1,A3)/A3     =LCM(F1,A3)/A3

=LCM(C1,A4)/A4     =LCM(D1,A4)/A4     =LCM(E1,A4)/A4     =LCM(F1,A4)/A4

=LCM(C1,A5)/A5     =LCM(D1,A5)/A5     =LCM(E1,A5)/A5     =LCM(F1,A5)/A5
Last edited by robleyd on Sat May 19, 2018 12:37 am, edited 1 time in total.
Reason: Tagged [Solved] and add CODE tags [robleyd, Moderator]
Libre Office 5.3 on Windows 10
harfis01
 
Posts: 2
Joined: Fri May 18, 2018 5:07 pm

Re: copying formulas

Postby FJCC » Fri May 18, 2018 6:35 pm

To make the references to the row in C1 and the column in A3 absolute, so they don't change, use
Code: Select all   Expand viewCollapse view
=LCM(C$1, $A3)/$A3

Absolute and mixed references are explained in this tutorial.
AOO 3.4 or 4.1 on MS Windows XP ( before 2013-08-03) or Windows 7
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: 6615
Joined: Sat Nov 08, 2008 8:08 pm
Location: Colorado, USA

Re: copying formulas

Postby harfis01 » Fri May 18, 2018 7:02 pm

Thank you very much for the reply.

I misunderstood the first instructions I found somewhere else about the absolute cells thinking if I put the $ in front of the cell reference ($D1) it would affect both values, the D and the 1.

I did find the tutorials here and the explanation given there was much better and I was able to figure out how to do what I wanted to do.
Libre Office 5.3 on Windows 10
harfis01
 
Posts: 2
Joined: Fri May 18, 2018 5:07 pm


Return to Calc

Who is online

Users browsing this forum: No registered users and 54 guests