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

Bring active cell back into view
Start at A1 and select to A9999 while writing a formula, you can't see A1 anymore. Press Ctrl+Backspace to bring active cell into view.

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,823
Messages
5,544,538
Members
410,619
Latest member
gregor222
Top