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


--
moncara
------------------------------------------------------------------------
moncara's Profile: http://www.excelforum.com/member.php...o&userid=35649
View this thread: http://www.excelforum.com/showthread...hreadid=554348

In A1 put this in:

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

HTH


--
Bearacade


------------------------------------------------------------------------
Bearacade's Profile: http://www.excelforum.com/member.php...o&userid=35016
View this thread: http://www.excelforum.com/showthread...hreadid=554348