# 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
LVL 9
###### Who is Participating?

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

Try the new one attached
Book1.xlsx
0

Commented:
Could it be as simple as the spreadsheet attached?

Or am I missing something?
Book1.xlsx
0

Author Commented:
I think that is fine.  I will let you know a little later.
0

Commented:
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

Author Commented:
Thanks mark_harris231

Looks like a lot of hidden power in Excel.

Rowby
0

Commented:
Yup... That's how I built the sample file  :-)
0

Author Commented:

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

Commented:
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

Author 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

Finance AnalystCommented:
ROUND will round up or down accordingly.

To force a round up use

=ROUNDUP(B1,0)

Thanks
Rob H
0

Author Commented:
Thanks all!<br /><br />Rowby
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.