dragging formulas

D

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

Luke M

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