Link to home
Start Free TrialLog in
Avatar of Rowby Goren
Rowby GorenFlag for United States of America

asked on

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
Avatar of n2fc
n2fc
Flag of United States of America image

Could it be as simple as the spreadsheet attached?

Or am I missing something?
Book1.xlsx
Avatar of Rowby Goren

ASKER

I think that is fine.  I will let you know a little later.
SOLUTION
Avatar of mark_harris231
mark_harris231
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Thanks mark_harris231

Looks like a lot of hidden power in Excel.

Rowby
Yup... That's how I built the sample file  :-)
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
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
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
ASKER CERTIFIED SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Thanks all!<br /><br />Rowby