linear increments

[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?

 

[BenjieLop]

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

 

[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...