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

How to fill five years of quarters?
Type 1Q-2023 in a cell. Grab the fill handle and drag down or right. After 4Q-2023, Excel will jump to 1Q-2024. Dash can be any character.

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,109,501
Messages
5,529,230
Members
409,857
Latest member
KailuaTown
Top