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
|