Formulas

[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

 

[Gord Dibben]

How about entering 1.1.1 in A1 then right-click and drag down. Release button
and "Fill Series"

Gord Dibben Excel MVP

 

[RagDyeR]

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

 

[Dave Peterson]

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>

 

[Gord Dibben]

By golly, you're right!

Guess OP will pick which list is the correct one.

Gord