octogonal repeat?
I am looking for a cell function that allows me to icrease at a
set top point of .8
EX. 1.1, 1.2, 1.3, 1.4, 1.5, 1.6, 1.7, 1.8, 2.0, 2.1, 2.2, 2.3 etc.
I am not sure if this formula will do exactly what you want... it starts at
1.0, not 1.1, and then continues as you have indicated.
=1+INT((ROWS($1:1)-1)/9)&"."&MOD((ROWS($1:1)-1),9)
The reason it does this is to keep each major "chapter" (the number before
the decimal point) the same length; otherwise the 1's group will have 8
numbers in it (1.1 to 1.8) whereas all the other groups will have 9 numbers
in them (x.0 to x.8).
Rick
|