keep cell constant in a formula

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

cell B2 is starting value B3 thru B60 subtracts from B2 which is constant. So to fill down =SUM ?b2? -(B asending #
Thank
JMH
 
Hi

Try this:
=$B$2-B3
and fill down. The B2 reference will not change - because it is absolute -
and the B3 reference will change as you drag it down - because it is
relative.


--
Andy.


JMH said:
cell B2 is starting value B3 thru B60 subtracts from B2 which is constant.
Click to expand...
So to fill down =SUM ?b2? -(B asending #)
 
Back
Top