I have a spread sheet - row 3 is a progression from 3-20 (3,4,5....19,20)
Column C has set values starting from row 6.
E6=E4*C6
E7=E4*E4*C7
E8=E*E4*E4*C8
E8=E4*E4*E4*E4*C9

F6=F4*C6
F7=F4*F4*C7
F8=F4*F4*F4*C8
F9=F4*F4*F4*F4*C9

if I use autofill by dragging across to fill columns G onwards the C7
becomes E7 then F7 thenG7 and so on, eg G8=G4*G4*G4*E8 instead of the correct
G4*G4*G4*C8 - same problem if I drag down - E10 becomes =E8*C10 instead of
=F4*F4*F4*F4*F4*C10.

All help gratefull received as I have have to extend this table in both
directions.

OS is XP Home - excel is 2002

Many Thanks


--
When would now be a good time to change?

=$E$4^ROW(A1)*$C6

and so on

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"The Life Coach" <(E-Mail Removed)> wrote in message
news:25E4BE31-C046-47BC-B9AB-(E-Mail Removed)...
>I have a spread sheet - row 3 is a progression from 3-20 (3,4,5....19,20)
> Column C has set values starting from row 6.
> E6=E4*C6
> E7=E4*E4*C7
> E8=E*E4*E4*C8
> E8=E4*E4*E4*E4*C9
>
> F6=F4*C6
> F7=F4*F4*C7
> F8=F4*F4*F4*C8
> F9=F4*F4*F4*F4*C9
>
> if I use autofill by dragging across to fill columns G onwards the C7
> becomes E7 then F7 thenG7 and so on, eg G8=G4*G4*G4*E8 instead of the
> correct
> G4*G4*G4*C8 - same problem if I drag down - E10 becomes =E8*C10 instead of
> =F4*F4*F4*F4*F4*C10.
>
> All help gratefull received as I have have to extend this table in both
> directions.
>
> OS is XP Home - excel is 2002
>
> Many Thanks
>
>
> --
> When would now be a good time to change?

Dear Bob,

many thanks - could you expand on that a bit please - I assume you mean i
repce my existing formulas with a variant on your suggestion - how would they
look for say cells E6,E7,F6&F7.

Many thanks again

Andy Smulian
--
When would now be a good time to change?


"Bob Phillips" wrote:

> =$E$4^ROW(A1)*$C6
>
> and so on
>
> --
> HTH
>
> Bob
>
> (there's no email, no snail mail, but somewhere should be gmail in my addy)
>
> "The Life Coach" <(E-Mail Removed)> wrote in message
> news:25E4BE31-C046-47BC-B9AB-(E-Mail Removed)...
> >I have a spread sheet - row 3 is a progression from 3-20 (3,4,5....19,20)
> > Column C has set values starting from row 6.
> > E6=E4*C6
> > E7=E4*E4*C7
> > E8=E*E4*E4*C8
> > E8=E4*E4*E4*E4*C9
> >
> > F6=F4*C6
> > F7=F4*F4*C7
> > F8=F4*F4*F4*C8
> > F9=F4*F4*F4*F4*C9
> >
> > if I use autofill by dragging across to fill columns G onwards the C7
> > becomes E7 then F7 thenG7 and so on, eg G8=G4*G4*G4*E8 instead of the
> > correct
> > G4*G4*G4*C8 - same problem if I drag down - E10 becomes =E8*C10 instead of
> > =F4*F4*F4*F4*F4*C10.
> >
> > All help gratefull received as I have have to extend this table in both
> > directions.
> >
> > OS is XP Home - excel is 2002
> >
> > Many Thanks
> >
> >
> > --
> > When would now be a good time to change?
>
>
>

If you put this slightly modified version in E6

=E$4^ROW($A1)*$C6

you should be able to drag it across and down and get what you want

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"The Life Coach" <(E-Mail Removed)> wrote in message
news1D04A41-D632-4B4E-B335-(E-Mail Removed)...
> Dear Bob,
>
> many thanks - could you expand on that a bit please - I assume you mean i
> repce my existing formulas with a variant on your suggestion - how would
> they
> look for say cells E6,E7,F6&F7.
>
> Many thanks again
>
> Andy Smulian
> --
> When would now be a good time to change?
>
>
> "Bob Phillips" wrote:
>
>> =$E$4^ROW(A1)*$C6
>>
>> and so on
>>
>> --
>> HTH
>>
>> Bob
>>
>> (there's no email, no snail mail, but somewhere should be gmail in my
>> addy)
>>
>> "The Life Coach" <(E-Mail Removed)> wrote in
>> message
>> news:25E4BE31-C046-47BC-B9AB-(E-Mail Removed)...
>> >I have a spread sheet - row 3 is a progression from 3-20
>> >(3,4,5....19,20)
>> > Column C has set values starting from row 6.
>> > E6=E4*C6
>> > E7=E4*E4*C7
>> > E8=E*E4*E4*C8
>> > E8=E4*E4*E4*E4*C9
>> >
>> > F6=F4*C6
>> > F7=F4*F4*C7
>> > F8=F4*F4*F4*C8
>> > F9=F4*F4*F4*F4*C9
>> >
>> > if I use autofill by dragging across to fill columns G onwards the C7
>> > becomes E7 then F7 thenG7 and so on, eg G8=G4*G4*G4*E8 instead of the
>> > correct
>> > G4*G4*G4*C8 - same problem if I drag down - E10 becomes =E8*C10 instead
>> > of
>> > =F4*F4*F4*F4*F4*C10.
>> >
>> > All help gratefull received as I have have to extend this table in both
>> > directions.
>> >
>> > OS is XP Home - excel is 2002
>> >
>> > Many Thanks
>> >
>> >
>> > --
>> > When would now be a good time to change?
>>
>>
>>

Bob,

A huge thank you - I'll look up those symbols and learn how to use them for
myself now - again - many many thanks.
--
When would now be a good time to change?


"Bob Phillips" wrote:

> If you put this slightly modified version in E6
>
> =E$4^ROW($A1)*$C6
>
> you should be able to drag it across and down and get what you want
>
> --
> HTH
>
> Bob
>
> (there's no email, no snail mail, but somewhere should be gmail in my addy)
>
> "The Life Coach" <(E-Mail Removed)> wrote in message
> news1D04A41-D632-4B4E-B335-(E-Mail Removed)...
> > Dear Bob,
> >
> > many thanks - could you expand on that a bit please - I assume you mean i
> > repce my existing formulas with a variant on your suggestion - how would
> > they
> > look for say cells E6,E7,F6&F7.
> >
> > Many thanks again
> >
> > Andy Smulian
> > --
> > When would now be a good time to change?
> >
> >
> > "Bob Phillips" wrote:
> >
> >> =$E$4^ROW(A1)*$C6
> >>
> >> and so on
> >>
> >> --
> >> HTH
> >>
> >> Bob
> >>
> >> (there's no email, no snail mail, but somewhere should be gmail in my
> >> addy)
> >>
> >> "The Life Coach" <(E-Mail Removed)> wrote in
> >> message
> >> news:25E4BE31-C046-47BC-B9AB-(E-Mail Removed)...
> >> >I have a spread sheet - row 3 is a progression from 3-20
> >> >(3,4,5....19,20)
> >> > Column C has set values starting from row 6.
> >> > E6=E4*C6
> >> > E7=E4*E4*C7
> >> > E8=E*E4*E4*C8
> >> > E8=E4*E4*E4*E4*C9
> >> >
> >> > F6=F4*C6
> >> > F7=F4*F4*C7
> >> > F8=F4*F4*F4*C8
> >> > F9=F4*F4*F4*F4*C9
> >> >
> >> > if I use autofill by dragging across to fill columns G onwards the C7
> >> > becomes E7 then F7 thenG7 and so on, eg G8=G4*G4*G4*E8 instead of the
> >> > correct
> >> > G4*G4*G4*C8 - same problem if I drag down - E10 becomes =E8*C10 instead
> >> > of
> >> > =F4*F4*F4*F4*F4*C10.
> >> >
> >> > All help gratefull received as I have have to extend this table in both
> >> > directions.
> >> >
> >> > OS is XP Home - excel is 2002
> >> >
> >> > Many Thanks
> >> >
> >> >
> >> > --
> >> > When would now be a good time to change?
> >>
> >>
> >>
>
>
>