dragging formulas
 

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?

dragging formulas
 

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

"Davo1" wrote:

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?

dragging formulas
 

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

Luke M
*Remember to click "yes" if this post helped you!*


"Davo1" wrote:

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?