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