linear increments


N

NewGuy100

Hi,
I am kind of new to excel and was wondering if excel is capable of
doing linear increments. I want increments that can vary, meaning in
one case i want to go from 0 to 10 in increments of 2 and in other
cases i want to go from 0 to 10 in increments of 5. The number of cells
change. Is it possible for excel to do this w/o having to specify the
number of cells needed?
 
Ad

Advertisements

B

BenjieLop

NewGuy100 said:
Hi,
I am kind of new to excel and was wondering if excel is capable o
doing linear increments. I want increments that can vary, meaning i
one case i want to go from 0 to 10 in increments of 2 and in othe
cases i want to go from 0 to 10 in increments of 5. The number of cell
change. Is it possible for excel to do this w/o having to specify th
number of cells needed?
One way ...

Enter this formula in Cell A2 and copy down until Cell A10:

=IF(OR($A$1=\"\",$B$1=\"\"),\"\",A1+$B$1

where

A1 contains the first value of your series (in your example, it is 0)
B1 contains the increment for your series

Hope this is what you are looking for.

Regards
 
Ad

Advertisements

J

JRod

I think that the answer can be something like this:

=IF(OR($A$1="";$B$1="");"";A1+$B$1)

As BenjieLop says, A1 contains the first value of your series (in your
example, it is 0)
and B1 contains the increment for your series
and you must enter the formula in Cell A2 and copy down until Cell A10.



--
JRod
http://EXCELer.blogspot.com

"NewGuy100" <NewGuy100.1wjvma_1128719103.9408@excelforum-nospam.com>
escreveu na mensagem
news:NewGuy100.1wjvma_1128719103.9408@excelforum-nospam.com...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads


Top