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

cell A-Z x cell B, how to do it simple?

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


Joined: 21 Oct 2010
Posts: 6

PostPosted: Thu Oct 21, 2010 4:03 am    Post subject: cell A-Z x cell B, how to do it simple? Reply with quote

I have a long column of numbers. ex. A1, A2, A3.... I allso have one cell with a specifik nuber, lets call it D5. In the cell next to the right of ex. A1, B1 in this case, I want it to multiply A1 with D5. The next B3, B3, B4.... cells should be A2*D5, A3*D5, A4*D5 and so on.

The first one is easy, but I can not find a way to make that formulla for all the cells in the B column.
If I ctrl+drag it changes not just the Ax but allso the D5 wich I do not want.

How do I make this in an easy way? Thanks!
Back to top
View user's profile Send private message
ken johnson
Super User
Super User


Joined: 23 Apr 2009
Posts: 2032
Location: Sydney, Australia

PostPosted: Thu Oct 21, 2010 4:15 am    Post subject: Reply with quote

=A1*D$5 in B1 will change to =A2*D$5 when filled down to B2. The $ sign stops the 5 in D$5 from changing when the formula is filled down.

Ken Jonson
_________________
If your problem has been solved please add "[Solved]" to the beginning of your first post title (edit button).
Back to top
View user's profile Send private message
ronnyo
General User
General User


Joined: 21 Oct 2010
Posts: 6

PostPosted: Thu Oct 21, 2010 5:00 am    Post subject: Reply with quote

Thanks a lot!
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