Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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? |
#2
|
|||
|
|||
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? |
#3
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to change Series order in a Combination Chart? | Charts and Charting in Excel | |||
How to change Series Order in a Combination Chart? | Excel Discussion (Misc queries) | |||
series graph -- one series being added to another series | Charts and Charting in Excel | |||
Dynamic series in Chart | Charts and Charting in Excel | |||
Extending a Chart Data Series from an Array - Can it be done? | Charts and Charting in Excel |