formula Query

[Carlie]

I have a column e.g:

=F5/F4
=F6/F4
=F7/F4
=F8/F4

That I would like to drag and drop to the bottom of the column to repeat as above instead of:

=F5/F4
=F6/F5
=F7/F6
=F8/F7

Is this possible?

Many thanks

[[email protected]]

Hi Carlie

the formula should be:

=F5/F$4

Regards,
Ivan

[Carlie]

Many thanks Ivan