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" <[email protected]> wrote in message
news:[email protected]...
>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" <[email protected]> wrote in message
news:[email protected]...
> 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" <[email protected]> wrote in message
> news:[email protected]...
>> 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