OpenOffice.org Forum at OOoForum.orgThe OpenOffice.org Forum
 
 [Home]   [FAQ]   [Search]   [Memberlist]   [Usergroups]   [Register
 [Profile]   [Log in to check your private messages]   [Log in

formulas with static and dynamic cell assignments

 
Post new topic   Reply to topic    OOoForum.org Forum Index -> OpenOffice.org Calc
View previous topic :: View next topic  
Author Message
qisback
Newbie
Newbie


Joined: 19 Mar 2009
Posts: 2

PostPosted: Thu Mar 19, 2009 11:00 pm    Post subject: formulas with static and dynamic cell assignments Reply with quote

First off hello and please forgive me if this question has been answered. I did use the search function and read through 3 pages however I couldn't find the answer.

I am trying to find a way of copying a formula into a number of cells/columns and allowing some cell references to increment and others to remain static.

For example a simple formula would read

=(D1*E1)/F1

if I were to paste/autofill this formula down the columns I would want it to read

=(D2*E2)/F1
=(D3*E3)/F1
=(D4*E4)/F1

however currently it simply increments like so

=(D1*E1)/F1
=(D2*E2)/F2
=(D3*E3)/F3
=(D4*E4)/F4

If anyone could help it would save a huge amount of time me punching in these formulas manually.
Back to top
View user's profile Send private message
keme
Moderator
Moderator


Joined: 30 Aug 2004
Posts: 2910
Location: Egersund, Norway

PostPosted: Fri Mar 20, 2009 1:27 am    Post subject: Reply with quote

Prefix with a dollar sign to indicate that an address element should be "absolute", or "static".
=(D1*E1)/F$1
Back to top
View user's profile Send private message
qisback
Newbie
Newbie


Joined: 19 Mar 2009
Posts: 2

PostPosted: Fri Mar 20, 2009 9:46 am    Post subject: Reply with quote

superb!

I got as far as

=(D1*E1)/$F1

which kept the "F" the same but still incrimented the cell number

so would

=(D1*E1)/$F$1

keep both the cell letter and number static?
Back to top
View user's profile Send private message
keme
Moderator
Moderator


Joined: 30 Aug 2004
Posts: 2910
Location: Egersund, Norway

PostPosted: Fri Mar 20, 2009 10:21 am    Post subject: Reply with quote

Correct.

Absolute/relative addressing applies to sheets in your spreadsheet file too, but not to named ranges (they're always absolute references).
Back to top
View user's profile Send private message
Display posts from previous:   
Post new topic   Reply to topic    OOoForum.org Forum Index -> OpenOffice.org Calc All times are GMT - 8 Hours
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group