Formula not copying

[cgendron]

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>

 

[hotabae]

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]

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.

 

[cgendron]

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.