How do I increment or decrement values in a column?
 

I have a column of the numbers 1 and 0. In an adjacent column, I want to
increment or decrement the value by 1. I know there's a simple way to do
this, but, I can't see it! Thanks for any help, OldKenGoat
Example:
Col A Col B
0 0
1 1
1 2
1 3
0 2
1 3
1 4
0 3
0 2
0 1
0 0
1 1
1 2
0 1

In B2:

=B1+(IF(A2=0,-1,1))

Fill down

--

Kind Regards,

Niek Otten

Microsoft MVP - Excel

"OldKenGoat" wrote in message
...
I have a column of the numbers 1 and 0. In an adjacent column, I want to
increment or decrement the value by 1. I know there's a simple way to do
this, but, I can't see it! Thanks for any help, OldKenGoat
Example:
Col A Col B
0 0
1 1
1 2
1 3
0 2
1 3
1 4
0 3
0 2
0 1
0 0
1 1
1 2
0 1

B1: =A1
B2: =B1+(IF(A2=0,-1,1))

and copy B2 down

--

HTH

RP
(remove nothere from the email address if mailing direct)


"OldKenGoat" wrote in message
...
I have a column of the numbers 1 and 0. In an adjacent column, I want to
increment or decrement the value by 1. I know there's a simple way to do
this, but, I can't see it! Thanks for any help, OldKenGoat
Example:
Col A Col B
0 0
1 1
1 2
1 3
0 2
1 3
1 4
0 3
0 2
0 1
0 0
1 1
1 2
0 1

Thanks, Niek. It worked perfectly!!!

Niek Otten wrote:
In B2:

=B1+(IF(A2=0,-1,1))

Fill down


"OldKenGoat" wrote in message
...
I have a column of the numbers 1 and 0. In an adjacent column, I
want to increment or decrement the value by 1. I know there's a
simple way to do this, but, I can't see it! Thanks for any help,
OldKenGoat Example:
Col A Col B
0 0
1 1
1 2
1 3
0 2
1 3
1 4
0 3
0 2
0 1
0 0
1 1
1 2
0 1