View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Trussell Trussell is offline
external usenet poster
 
Posts: 1
Default 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?