• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 275
  • Last Modified:

Increments formula for excel

Hello

I have  a spreadsheet that starts with column A1

There is a number in it.  100,000.  

I am looking for a formula that when I drag down the column, it increases the number by 10,000

For example,

100,000
110,000
120,000

Etc.

That's it!

Thanks

Rowby
0
Rowby Goren
Asked:
Rowby Goren
3 Solutions
 
n2fcCommented:
Could it be as simple as the spreadsheet attached?

Or am I missing something?
Book1.xlsx
0
 
Rowby GorenAuthor Commented:
I think that is fine.  I will let you know a little later.
0
 
mark_harris231Commented:
Points to n2fc if it works for you, but something else to be aware of.  If you start a pattern in any two cells, Excel will be able to recognize the pattern and repeat it as you drag down.

Example:  A1 = 100,000 / A2 = 110,000     Select Cells A1 and A2, then drag down as far as needed.  Each cell will increase by 10,000.   You can do the same horizontally.  You can also complete alphabetic (a-z), days of the week (Sunday - Saturday) and most date formats.
0
What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

 
Rowby GorenAuthor Commented:
Thanks mark_harris231

Looks like a lot of hidden power in Excel.

Rowby
0
 
n2fcCommented:
Yup... That's how I built the sample file  :-)
0
 
Rowby GorenAuthor Commented:
Working fine.  One additional refinement.

I need the number to round up to the next number if there the result of the formula includes a decimal.

For example,

If the result of the formula is  

15.5  

I want the result to be 16.

I always want it rounding UP, not down.

Thanks!

Rowby
0
 
n2fcCommented:
Just surround the formula with "=ROUND(xxx,1)"... where xxx is the current contents...

I will try to edit & upload a new sample file
Book1.xlsx
0
 
Rowby GorenAuthor Commented:
Hi

Hi,  I downloaded the file, but am having trouble getting it to work.

It might be easier for me to figure out what is what if you would modify it and make the number in A1 as 100 and roundup increment it by a number with a decimal, such as  15.3

Thanks

Rowby
0
 
n2fcCommented:
Sorry... I misspoke before... shoulda been "ROUND(xxx,0)"  

Try the new one attached
Book1.xlsx
0
 
Rob HensonIT & Database AssistantCommented:
ROUND will round up or down accordingly.

To force a round up use

=ROUNDUP(B1,0)

Thanks
Rob H
0
 
Rowby GorenAuthor Commented:
Thanks all!<br /><br />Rowby
0

Featured Post

Hire Technology Freelancers with Gigs

Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now