View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
MartinW[_2_] MartinW[_2_] is offline
external usenet poster
 
Posts: 168
Default 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?