Help with autofilling formulas

[moncara]

I need help autofilling a formula similar to this:


a1
=c4/(b1-af1)/24

a2
=c5/(b1-af1)/24

a3
=c6/(b1-af1)/24

I would like the C to increase by 1 and the (B1-AF1)/24 to remain
constant. Any help would be appreciated.

Bryan

 

[Bearacade]

In A1 put this in:

=c4/($b$1-$af$1)/24

HTH