# Can a formula do this?

U

#### User

Trying to figure out if this is at all possible using a formula in order to be able to use cell/row pull-down.

Example-1: A cell has the value of 2, say A1. B1 should be the value of 1 and C1 should be the value of 2.

Example-2: A cell has the value of 4, say A2. B2 should be the value of 1, C2 should be the value of 2, B3 should be the value of 3 and C3 should be the value of 4.

The value in cell A# will be a multiple of 2 to a maximum value of 16.

Thanks

C

#### Claus Busch

Hi,

Am Sun, 11 Aug 2013 18:21:30 -0700 (PDT) schrieb User:
Trying to figure out if this is at all possible using a formula in order to be able to use cell/row pull-down.

Example-1: A cell has the value of 2, say A1. B1 should be the value of 1 and C1 should be the value of 2.

Example-2: A cell has the value of 4, say A2. B2 should be the value of 1, C2 should be the value of 2, B3 should be the value of 3 and C3 should be the value of 4.

The value in cell A# will be a multiple of 2 to a maximum value of 16.

write 1 in B1. And in C1:
=IFERROR(IF(B1+1<=\$A1,B1+1,""),"")
and copy to right

Regards
Claus B.