That's the point of dragging a formula down, so that the formula stays the same but the cell references adjust automatically (B2 > B3 > B4, etc.)

If your values aren't updating, but the formula is, you most likely have Calculation set to Manual.

Go to Tools > Options > Calculation tab > click 'Automatic' > click OK