Formula not copying

cgendron

Board Regular
Joined
Apr 13, 2011
Messages
111
Hi all, my formula in column D is not calculating correctly. I'm just dividing column A by B but its just copying the results from the first line when i drag the formula down. I feel like there is something simple that i need to do to fix it but cant figure out why it just starting doing this.



<colgroup><col width="64" span="4" style="width:48pt"></colgroup><tbody>
</tbody>
$1,226.00 8($110.86)$153.25
$950.00 8($50.76)$153.25
$173.00 1$0$153.25
$268.00 2$0$153.25
$95.00 1($31.27)$153.25
$231.00 1$0$153.25

<colgroup><col width="64" span="4" style="width:48pt"> </colgroup><tbody>
</tbody>
 

Some videos you may like

Excel Facts

Can a formula spear through sheets?
Use =SUM(January:December!E7) to sum E7 on all of the sheets from January through December

hotabae

Board Regular
Joined
Apr 18, 2018
Messages
167
Is the formula in one of them / all of them this?

(=$A$1/$B$1) or (=A$1/B$1)? Any dollar signs would be a culprit.

Otherwise, what is showing in them?
 

AlKey

Active Member
Joined
Oct 15, 2013
Messages
395
Hi all, my formula in column D is not calculating correctly. I'm just dividing column A by B but its just copying the results from the first line when i drag the formula down. I feel like there is something simple that i need to do to fix it but cant figure out why it just starting doing this.



<colgroup><col width="64" span="4" style="width:48pt"></colgroup><tbody>
</tbody>
$1,226.00 8($110.86)$153.25
$950.00 8($50.76)$153.25
$173.00 1$0$153.25
$268.00 2$0$153.25
$95.00 1($31.27)$153.25
$231.00 1$0$153.25

<colgroup><col width="64" span="4" style="width:48pt"> </colgroup><tbody>
</tbody>

If you simply divide Col A by Col B and copy down, and the value stays the same, check if the Calculations Options to make sure that the settings are set to Automatic instead of Manual.
 
Last edited:

cgendron

Board Regular
Joined
Apr 13, 2011
Messages
111
Perfect, yup the calc options were set to manual. Got it fixed now thanks! i knew it had to be something stupid. Thanks again!


If you simply divide Col A by Col B and copy down, and the value stays the same, check if the Calculations Options to make sure that the settings are set to Automatic instead of Manual.
 

Watch MrExcel Video

Forum statistics

Threads
1,113,836
Messages
5,544,600
Members
410,625
Latest member
Hemantjain86
Top