how do I do a formula to automatically put numbers in a cell

if a1 = 1

I would like a2, a3, a4, a5, a6..... to be 2,3,4,1,2,3,4.....

how do I make the sequence change from 4 back to 1

ie. a1 maybe 3

thus a2,a3,a4,a5,6......would be 4,1,2,3,4,12.......

what would the formulas be in the cells


andrewm


--
andrewm
------------------------------------------------------------------------
andrewm's Profile: http://www.excelforum.com/member.php...o&userid=23130
View this thread: http://www.excelforum.com/showthread...hreadid=484630

andrewm Wrote:
how do I do a formula to automatically put numbers in a cell

if a1 = 1

I would like a2, a3, a4, a5, a6..... to be 2,3,4,1,2,3,4.....

how do I make the sequence change from 4 back to 1

ie. a1 maybe 3

thus a2,a3,a4,a5,6......would be 4,1,2,3,4,12.......

what would the formulas be in the cells


andrewm

Hi Andrew

In B1 put this formula =IF(A1<4,A1+1,A1-3) and drag across as far as
required


--
Paul Sheppard


------------------------------------------------------------------------
Paul Sheppard's Profile: http://www.excelforum.com/member.php...o&userid=24783
View this thread: http://www.excelforum.com/showthread...hreadid=484630

Same result with different approach:

In A2 type: =IF(MOD(A1+1,4)=0,4,MOD(A1+1,4))

and drag copy down as far as necessary


--
Cutter
------------------------------------------------------------------------
Cutter's Profile: http://www.excelforum.com/member.php...fo&userid=9848
View this thread: http://www.excelforum.com/showthread...hreadid=484630

In A2 type: =IF(MOD(A1+1,4)=0,4,MOD(A1+1,4))

I think this may be equivalent:
=MOD(A1,4)+1

However, another option might be:
A1: =MOD(ROW()-1,4)+1

...and copy down
HTH
--
Dana DeLouis
Win XP & Office 2003


"Cutter" wrote in
message ...

Same result with different approach:

In A2 type: =IF(MOD(A1+1,4)=0,4,MOD(A1+1,4))

and drag copy down as far as necessary


--
Cutter
------------------------------------------------------------------------
Cutter's Profile:
http://www.excelforum.com/member.php...fo&userid=9848
View this thread: http://www.excelforum.com/showthread...hreadid=484630