Formulas

  • Thread starter Thread starter Richard Gendron
  • Start date Start date
R

Richard Gendron

Hi there
I have a cell that contains 1.1.1, I would a formulas that would increase it
by 0.0.1
So I would have

1.1.1
1.1.2
1.1.3
etc.

Can anyone help me ?
Tks, Rg
 
How about:

=TEXT(1+SUBSTITUTE(F1,".",""),"0\.0\.0")

I dragged down and got this:

1.1.2
1.1.3
1.1.4
1.1.5
1.1.6
1.1.7
1.1.8
1.1.9
1.2.0
1.2.1
1.2.2
1.2.3
1.2.4
1.2.5
1.2.6
1.2.7
1.2.8
1.2.9
1.3.0
1.3.1


Is that what you wanted/expected?
 
How about entering 1.1.1 in A1 then right-click and drag down. Release button
and "Fill Series"

Gord Dibben Excel MVP
 
How about entering
1.1.1 in A1, and
1.1.2 in A2, and
just select both cells, and drag down.
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================

"Gord Dibben" <gorddibbATshawDOTca> wrote in message
How about entering 1.1.1 in A1 then right-click and drag down. Release
button
and "Fill Series"

Gord Dibben Excel MVP
 
Both of these resulted in a different value when it hit 10:

1.1.1
1.1.2
1.1.3
1.1.4
1.1.5
1.1.6
1.1.7
1.1.8
1.1.9
1.1.10
1.1.11
1.1.12
1.1.13
1.1.14
1.1.15
1.1.16
1.1.17
1.1.18

Heck if I know which is correct for the OP.
<vbg>
 
Back
Top