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.
Not sure how you are using it but if say A1 contains a number like 1.1 then
this is A2 will let you copy down as requested
=IF(RIGHT(A1,1)="8",A1+0.2,A1+0.1)
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).
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).
I forgot to mention in my first post, but I am sure you figured it out, put
this formula in **any** cell you want and then copy it down as far as
needed.
I forgot to mention in my first post, but I am sure you figured it out,
put this formula in **any** cell you want and then copy it down as far as
needed.
One final thought... I see the other solutions offered are generating
numerical values (my formulas as written generate text values)... if you
want numerical values, just encase either of my formulas in parentheses and
precede that with the double unary (minus sign) symbol....
To start at 1.0
***************
=--(1+INT((ROWS($1:1)-1)/9)&"."&MOD((ROWS($1:1)-1),9))
To start at 1.1
***************
=--(1+INT((ROWS($1:2)-1)/9)&"."&MOD((ROWS($1:2)-1),9))
Rick
Ask a Question
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.