View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Rick Rothstein \(MVP - VB\) Rick Rothstein \(MVP - VB\) is offline
external usenet poster
 
Posts: 2,202
Default 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