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.
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.