Formula for returning the next value unless value in adjacent column in 1

[helsbelz]

The first two columns are an example of my data set; I would like a formula for the 3rd column (Length+1) which will give me the length at the next age (i.e the value in the cell below in most cases) unless the following age is 1 in which case I want it to return zero. Any help, much appreciated.

Age Length Length+1
1 22 51
2 51 78
3 78 94
4 94 0
1 31 46
2 46 69
3 69 85
4 85 96
5 96 103
6 103 0
1 19 36
2 36 52
3 52 0

[Richard Buttrey]

Hi,

Welcome to the forum.

It would assist greatly if you'd manually enter the results you expect since we can interpret your request in more than one way. However if it is simply a value which is one greater than the row below then in C2 copied down

Please Login or Register  to view this content.

Somehow though I doubt that's what you mean.

[canapone]

Hi,

a possible solution to check if the cell below in greater than zero

=(A3+1)*(A3>0)

Regards

------------

Edit: I'm a slow writer

[helsbelz]

Thank you Richard that is exactly what I meant, brilliant.