LinuxQuestions.org
Support LQ: Use code LQ3 and save $3 on Domain Registration
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 06-23-2009, 08:53 PM   #1
SangrelX
LQ Newbie
 
Registered: Jun 2009
Posts: 6

Rep: Reputation: 0
Post Help Please - Open Office CALC Formula's


Ok guys ive been fighting with this one for a bit and am not sure how to do it.


I have a Set of 5 Numbers that are all an addition of 4 then at the 5th number it needs to add 2036 to the cell and continue counting up by 4s then again on that 5th add another 2036 and so and and so fourth

EXAMPLE
A
1:2020 -- ADD 4 = 2024
2:2024 -- ADD 4 = 2028
3:2028 -- ADD 4 = 2032
4:2032 -- ADD 4 = 2036
5:2036 -- HERE it changes and ADDS 2036 to 2036 to equal the start of the next set aka 4072

6:4072 -- ADD 4 = 4076
7:4076 -- ADD 4 = 4080
8:4080 -- ADD 4 = 4084
9:4084 -- ADD 4 = 4088
10:4088 -- AGAIN ADD 2036 to 4088 and you get -- 6124 to start the next set of 5

11:6124 -- ADD 4 - 6128
12:6128 -- ADD 4 - 6132

and so on and so on!

now how in the heck can I set CALC to allow me to easily fill DOWN the rows without RETYPING the formulas?

I have do 300 of these sets

Thanks guys for any help I hope you all understand what I am asking!
 
Old 06-23-2009, 09:42 PM   #2
jlinkels
Senior Member
 
Registered: Oct 2003
Location: Bonaire
Distribution: Debian Lenny/Squeeze/Wheezy/Sid
Posts: 4,052

Rep: Reputation: 484Reputation: 484Reputation: 484Reputation: 484Reputation: 484
In A1 enter 2020
In B1 enter =A1+4
In A2 enter =B1
Copy A2 to clipboard
Mark a a number of rows in column A equal to what you need (about 1500). Paste.
Copy B1 to clipboard
Paste this to B2..B4
Edit B5 and change =A4+4 to =A4+2036
Mark B1..B5 and copy to clipboard
Mark B6 to B1500 or so
Put cursor at B6
Paste

Code:
2020	2024
2024	2028
2028	2032
2032	2036
2036	4072
4072	4076
4076	4080
4080	4084
4084	4088
4088	6124
6124	6128
6128	6132
6132	6136
6136	6140
6140	8176
8176	8180
8180
jlinkels
 
  


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
Open Office Calc in Debian Sid Zaskar Debian 5 11-23-2007 01:26 PM
Open Office Calc question Zaskar Linux - Desktop 3 11-21-2007 02:03 PM
LXer: Office shootout: OpenOffice.org Calc vs. Microsoft Excel LXer Syndicated Linux News 0 10-11-2007 05:40 PM
elapsed time formula for open office calc philosophe Linux - Software 1 03-30-2005 05:32 AM


All times are GMT -5. The time now is 10:01 PM.

Main Menu
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
identi.ca: @linuxquestions
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration