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