Can a formula do this?
 

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

Can a formula do this?
 

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.
--
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2