Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
octogonal repeat?
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) -- -John Please rate when your question is answered to help us and others know what is helpful. "08Challenger" wrote: 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. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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). However, if you really wanted to start at 1.1 and continue as you showed, this minor modification to the formula I posted will do that... =1+INT((ROWS($1:2)-1)/9)&"."&MOD((ROWS($1:2)-1),9) 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. Rick |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
octogonal repeat?
=IF((MOD(A1,1)<=0.8),A1+0.1,INT(A1)+1)
"08Challenger" wrote: 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. |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
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). However, if you really wanted to start at 1.1 and continue as you showed, this minor modification to the formula I posted will do that... =1+INT((ROWS($1:2)-1)/9)&"."&MOD((ROWS($1:2)-1),9) 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Repeat Operations | Excel Discussion (Misc queries) | |||
repeat summing? | Excel Worksheet Functions | |||
how to repeat rows at the bottom while using the rows repeat at to | Setting up and Configuration of Excel | |||
Title Cut Off if Rows to Repeat & Columns to Repeat are Both Selec | Excel Discussion (Misc queries) | |||
Don't want to repeat a selection | Excel Discussion (Misc queries) |