how do i extend the series of a portion of a formula?
 

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?

insert a $ in front of the number to stay on the same row
=IF(B1=1,C$250*3,0)

"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?

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?