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
Rowby GorenAsked:
Who is Participating?
 
n2fcCommented:
Sorry... I misspoke before... shoulda been "ROUND(xxx,0)"  

Try the new one attached
Book1.xlsx
0
 
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
Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

 
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
 
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
 
Rob HensonFinance AnalystCommented:
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
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.

All Courses

From novice to tech pro — start learning today.