Thread
:
Simplify equation
View Single Post
#
1
Posted to microsoft.public.excel.worksheet.functions
Stephen Christian[_2_]
external usenet poster
Posts: 4
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
Reply With Quote
Stephen Christian[_2_]
View Public Profile
Find all posts by Stephen Christian[_2_]