dragging formulas

[Davo1]

when I drag a formula down, it does not grab the next row's value correctly.
It shows the result from the original cell dragged. What can I do?

 

[David]

what is the formula that you are trying to drag, does it have $ in it?

 

[Luke M]

In addition to David's suggestion, are you in manual calculation mode? Try
pressing F9.