Forum Discussion
Joe_Ida
Jun 21, 2023Copper Contributor
Divide a column of numbers by a constant figure
I am ring to divide a column of numbers by a constant number in another cell Using the A2/$B$7 Copy and paste but always the same result when origin numbers are different
Riny_van_Eekelen
Jun 22, 2023Platinum Contributor
What calculation mode do you have? I suspect it's on Manual. Make sure it's set to Automatic.