Democratic Underground Latest Greatest Lobby Journals Search Options Help Login
Google

Excel/Open Office question for the experts

Printer-friendly format Printer-friendly format
Printer-friendly format Email this thread to a friend
Printer-friendly format Bookmark this thread
This topic is archived.
Home » Discuss » The DU Lounge Donate to DU
 
DS1 Donating Member (1000+ posts) Send PM | Profile | Ignore Wed Dec-03-08 11:44 AM
Original message
Excel/Open Office question for the experts
I have a sequence of numbers in the first column. 1,2,3 etc. However, I need to offset them by a number, lets say 50, to make them 51, 52, 53.

Is there a function to do this automatically?


Printer Friendly | Permalink |  | Top
LeftyFingerPop Donating Member (1000+ posts) Send PM | Profile | Ignore Wed Dec-03-08 11:48 AM
Response to Original message
1. If the "50" is a constant, what I do is....
In the first cell, type "=a1+50"

Then, copy the formula down and it will take the number in each cell and add 50 to it.
Printer Friendly | Permalink |  | Top
 
LeftyFingerPop Donating Member (1000+ posts) Send PM | Profile | Ignore Wed Dec-03-08 11:51 AM
Response to Reply #1
2. Note..."a1" or whatever the starting cell location happens to be.
Printer Friendly | Permalink |  | Top
 
LeftyFingerPop Donating Member (1000+ posts) Send PM | Profile | Ignore Wed Dec-03-08 12:00 PM
Response to Reply #2
3. To further clarify....
I'm assuming the numbers are sequential and the 50 is constant.

In cell a1, there is the number 1.

Create another column to show the results....say in column b.

col b1 = "=a1+50"

then, copy this down and the a1 will change to a2, a3, etc.

i don't know, I hope this helps. It is something like this...gotta play around with it.
Printer Friendly | Permalink |  | Top
 
DS1 Donating Member (1000+ posts) Send PM | Profile | Ignore Wed Dec-03-08 12:03 PM
Response to Reply #2
4. perfect
thanks!
Printer Friendly | Permalink |  | Top
 
LeftyFingerPop Donating Member (1000+ posts) Send PM | Profile | Ignore Wed Dec-03-08 01:02 PM
Response to Reply #4
5. You're welcome...glad it worked! n/t
Printer Friendly | Permalink |  | Top
 
DU AdBot (1000+ posts) Click to send private message to this author Click to view 
this author's profile Click to add 
this author to your buddy list Click to add 
this author to your Ignore list Mon May 06th 2024, 03:54 AM
Response to Original message
Advertisements [?]
 Top

Home » Discuss » The DU Lounge Donate to DU

Powered by DCForum+ Version 1.1 Copyright 1997-2002 DCScripts.com
Software has been extensively modified by the DU administrators


Important Notices: By participating on this discussion board, visitors agree to abide by the rules outlined on our Rules page. Messages posted on the Democratic Underground Discussion Forums are the opinions of the individuals who post them, and do not necessarily represent the opinions of Democratic Underground, LLC.

Home  |  Discussion Forums  |  Journals |  Store  |  Donate

About DU  |  Contact Us  |  Privacy Policy

Got a message for Democratic Underground? Click here to send us a message.

© 2001 - 2011 Democratic Underground, LLC