When attempting to round coordinates to the hundredth decimal point I use the formula =round(A1,2).  When I use the drag function to copy the formula to the remainder of cells in the column all formula information carries to each cell with the proper cell name.  After the fact, the formulas are correct but the round function does not execute properly and shows the same figure correct for A1.  I refresh the column with no avail to execute the formula correctly.  Has anyone experienced issues with this or know of a fix?

When attempting to round coordinates to the hundredth decimal point I use the formula =round(A1,2).  When I use the drag function to copy the formula to the remainder of cells in the column all formula information carries to each cell with the proper cell name.  After the fact, the formulas are correct but the round function does not execute properly and shows the same figure correct for A1.  I refresh the column with no avail to execute the formula correctly.  Has anyone experienced issues with this or know of a fix?

I've had similar issues. The big difference is that my formula ended up full of GETPIVOTDATA functions. Is the formula you posted exactly what you see in Excel? If not, can you post the formula exactly as is is.

Gordon

Hi MRMcDaniel0118,

Do you mean the formula =round(A1,2) dont change when youre dragging the function to other cells? And you wonder the A1 should be changed over the cells, such as =round(A1,2); =round(A2,2); =round(A3,2)

As shown in the following figure, please check if your formula is =round($A$1,2) or =round(A$1,2).

If yes, you can change the formula to =round(A1,2) without Absolute Reference, and dragging the function again.

If my understanding is incorrect, I suggest you can provide us a sample via OneDrive and share the location, so that we can get more accurate solutions to this problem. I am glad to help and forward to your reply.

Regards,