I also meant to add drag the formula with the $ down
"fraustrated" wrote:
Hi,
In MS excel, I have a formula with a couple of fields in it that I want to
drag down, but I only want one of the fields in the formula to auto-extend
(as in a series). I want the other field to remain constant.
This is an example of how I want my series to appear:
=IF(B1=1,C250*3,0)
=IF(B2=1,C250*3,0)
=IF(B3=1,C250*3,0)
...
=IF(B100=1,C250*3,0)
This is what Excel does whenever I drag the auto-fill button.
=IF(B1=1,C250*3,0)
=IF(B2=1,C251*3,0)
=IF(B3=1,C252*3,0)
...
=IF(B100=1,C350*3,0)
Notice on the first example that Column B is auto-extended, while column C
remains at C250. Whenever I drag down on the auto-fill, it always extends
both the B and C column values, I only want the B column to auto-extend.
How do I accomplish this using fill-dragging?
|