Fill range don't change the formula, Help was no help. Please hel
 

I looked through Help and I looked in this forum - I am still not able to get
the fill formatting to do what I want.
C D
2 40
3 350 140
4 400
5 670
6 40
7 200
8 350

cell 3B has the formula =C3*(D2/100)

When I select 3B and drag down my formula changes the 3 and 2 in the formula
to reflect the relationship it statred with.
Can I get this to not happen?

Fill range don't change the formula, Help was no help. Please hel
 

Hi Russell,

Check the Help file on 'absolute references' for a complete explanation.

Changing your formula to this will do what you require.
=C$3*(D$2/100)

HTH
Martin

"Trussell" wrote in message
...
I looked through Help and I looked in this forum - I am still not able to
get
the fill formatting to do what I want.
C D
2 40
3 350 140
4 400
5 670
6 40
7 200
8 350

cell 3B has the formula =C3*(D2/100)

When I select 3B and drag down my formula changes the 3 and 2 in the
formula
to reflect the relationship it statred with.
Can I get this to not happen?

Fill range don't change the formula, Help was no help. Please hel
 

I guess you do not want D2 to change but want C3 to change to C4, C5,.... If
that is the case then try

=C3*(D$2/100)

As Chip Pearson posted elsewhere today
______________
If you don't want part of a reference to change, put a $ character
before that part of the reference. Excel won't change it when you copy
it down. E.g.,

=$A$1 change neither row nor column
=A1 change both row and column
=$A1 change row but not column
=A$1 change column but not row
__________________________________________________ _____
You can select the reference and press F4 repeatedly to cycle through the
choices.
--
Always provide your feedback so that others know whether the solution worked
or problem still persists ...


"Trussell" wrote:

I looked through Help and I looked in this forum - I am still not able to get
the fill formatting to do what I want.
C D
2 40
3 350 140
4 400
5 670
6 40
7 200
8 350

cell 3B has the formula =C3*(D2/100)

When I select 3B and drag down my formula changes the 3 and 2 in the formula
to reflect the relationship it statred with.
Can I get this to not happen?

Fill range don't change the formula, Help was no help. Please hel
 

Hi,

As an additional piece of info:

=C3*(D2/100)
can be written
=C3*D2/100
no need for parens here. If my memory serves me division and multiplication
are said to be distributive, which means their order is unimportant, so you
don't need the parens.

Primer on relative and absolute cell references

By default almost all Excel formulas are relative - they adjust when you
copy them. For example =SUM(A1:A10) in cell A11 is copied to B11 it becomes
=SUM(B1:B11) its references are relative to the location of the formula.
You can make any portion of a reference absolute by putting a $ in front of
it. An absolute reference does not change when you copy it.

Cell references come in 4 variations:
A1 relative
$A$1 absolute
$A1 mixed - the A is absolute, the 1 is relative
A$1 mixed - the A is relative, the 1 is absolute

These ideas are a core component of Excel's formulas and everyone should
master them!

When you copy a formula down a column, in a formula reference like
=SUM(A1:D1), the row numbers change but the column letter do not. To make
the row numbers fixed, absolute, you can modify the formula to read
=SUM(A$1:D$1). We might call this absolute but actually its mixed, but since
we are copying up or down a column and not left or right, all portions of the
references remain unchanging.

Why should you know this? If you write a formula and copy it and then find
you need to go back and modify it to get it to refer to the correct cells, it
usually means you don't understand the concept of absolute/relative cell
references. But more importantly you are working too hard, editing those
formulas.


If this is helpful, please click the Yes button.
--
Thanks,
Shane Devenshire


"Trussell" wrote:

I looked through Help and I looked in this forum - I am still not able to get
the fill formatting to do what I want.
C D
2 40
3 350 140
4 400
5 670
6 40
7 200
8 350

cell 3B has the formula =C3*(D2/100)

When I select 3B and drag down my formula changes the 3 and 2 in the formula
to reflect the relationship it statred with.
Can I get this to not happen?