Rowby Goren
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
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
ASKER
I think that is fine. I will let you know a little later.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks mark_harris231
Looks like a lot of hidden power in Excel.
Rowby
Looks like a lot of hidden power in Excel.
Rowby
Yup... That's how I built the sample file :-)
ASKER
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
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
I will try to edit & upload a new sample file
Book1.xlsx
ASKER
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
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks all!<br /><br />Rowby
Or am I missing something?
Book1.xlsx