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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top