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
|