Simplify equation
 

Cna someone simplify this for me please? Starting at b2

=IF((MOD(COLUMN(),6))=0,6,IF((MOD(COLUMN(),6))=1,7 ,(MOD(COLUMN(),6))))

so i get 2 3 4 5 6 7 2 3 4 5 6 7 2 etc in row 2

Thanks

Simplify equation
 

Here is one way... In B2 enter

=IF(OR(COLUMN()=2,A2=7),2,A2+1)

and copy across row 2 as needed.

Hope this helps,

Hutch

"Stephen Christian" wrote:

Cna someone simplify this for me please? Starting at b2

=IF((MOD(COLUMN(),6))=0,6,IF((MOD(COLUMN(),6))=1,7 ,(MOD(COLUMN(),6))))

so i get 2 3 4 5 6 7 2 3 4 5 6 7 2 etc in row 2

Thanks

Simplify equation
 

In B2 enter the below and copy to the right as required...
=MOD(COLUMN(F1),6)+2

If this post helps click Yes
---------------
Jacob Skaria


"Stephen Christian" wrote:

Cna someone simplify this for me please? Starting at b2

=IF((MOD(COLUMN(),6))=0,6,IF((MOD(COLUMN(),6))=1,7 ,(MOD(COLUMN(),6))))

so i get 2 3 4 5 6 7 2 3 4 5 6 7 2 etc in row 2

Thanks

Simplify equation
 

Another way (not a formula):

Enter 2 - 7 in B2 through G2.
Select B2:G2. Position the cursor over the dot in the lower right corner of
G2 (the cursor should change to a plus sign).
Hold down the Ctrl key and drag across row 2 as needed.

Hope this helps,

Hutch

"Stephen Christian" wrote:

Cna someone simplify this for me please? Starting at b2

=IF((MOD(COLUMN(),6))=0,6,IF((MOD(COLUMN(),6))=1,7 ,(MOD(COLUMN(),6))))

so i get 2 3 4 5 6 7 2 3 4 5 6 7 2 etc in row 2

Thanks

Simplify equation
 

=MOD(COLUMN()-2,6)+2
--
David Biddulph

"Stephen Christian" wrote in
message ...
Cna someone simplify this for me please? Starting at b2

=IF((MOD(COLUMN(),6))=0,6,IF((MOD(COLUMN(),6))=1,7 ,(MOD(COLUMN(),6))))

so i get 2 3 4 5 6 7 2 3 4 5 6 7 2 etc in row 2

Thanks

Simplify equation
 

Here is another method for you to consider. Put the number 2 in cell B2, put
this formula in C2 and copy it across as far as needed...

=IF(B2=7,2,B2+1)

--
Rick (MVP - Excel)


"Stephen Christian" wrote in
message ...
Cna someone simplify this for me please? Starting at b2

=IF((MOD(COLUMN(),6))=0,6,IF((MOD(COLUMN(),6))=1,7 ,(MOD(COLUMN(),6))))

so i get 2 3 4 5 6 7 2 3 4 5 6 7 2 etc in row 2

Thanks