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.


[TABLE="width: 256"]
<colgroup><col width="64" span="4" style="width:48pt"></colgroup><tbody>[TR]
[TD="class: xl66"][/TD]
[TD="class: xl63"][/TD]
[TD="class: xl64"][/TD]
[TD="class: xl67, align: right"] [/TD]
[/TR]
</tbody>[/TABLE]
[TABLE="width: 256"]
<colgroup><col width="64" span="4" style="width:48pt"> </colgroup><tbody>[TR]
[TD="class: xl68, width: 64"]$1,226.00 [/TD]
[TD="class: xl65, width: 64"]8[/TD]
[TD="class: xl67, width: 64"]($110.86)[/TD]
[TD="class: xl69, width: 64, align: right"]$153.25 [/TD]
[/TR]
[TR]
[TD="class: xl68"]$950.00 [/TD]
[TD="class: xl65"]8[/TD]
[TD="class: xl67"]($50.76)[/TD]
[TD="class: xl69, align: right"]$153.25 [/TD]
[/TR]
[TR]
[TD="class: xl68"]$173.00 [/TD]
[TD="class: xl65"]1[/TD]
[TD="class: xl66"]$0[/TD]
[TD="class: xl69, align: right"]$153.25 [/TD]
[/TR]
[TR]
[TD="class: xl68"]$268.00 [/TD]
[TD="class: xl65"]2[/TD]
[TD="class: xl66"]$0[/TD]
[TD="class: xl69, align: right"]$153.25 [/TD]
[/TR]
[TR]
[TD="class: xl68"]$95.00 [/TD]
[TD="class: xl65"]1[/TD]
[TD="class: xl67"]($31.27)[/TD]
[TD="class: xl69, align: right"]$153.25 [/TD]
[/TR]
[TR]
[TD="class: xl68"]$231.00 [/TD]
[TD="class: xl65"]1[/TD]
[TD="class: xl66"]$0[/TD]
[TD="class: xl69, align: right"]$153.25 [/TD]
[/TR]
</tbody>[/TABLE]

 

[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.


[TABLE="width: 256"]
<colgroup><col width="64" span="4" style="width:48pt"></colgroup><tbody>[TR]
[TD="class: xl66"][/TD]
[TD="class: xl63"][/TD]
[TD="class: xl64"][/TD]
[TD="class: xl67, align: right"] [/TD]
[/TR]
</tbody>[/TABLE]
[TABLE="width: 256"]
<colgroup><col width="64" span="4" style="width:48pt"> </colgroup><tbody>[TR]
[TD="class: xl68, width: 64"]$1,226.00 [/TD]
[TD="class: xl65, width: 64"]8[/TD]
[TD="class: xl67, width: 64"]($110.86)[/TD]
[TD="class: xl69, width: 64, align: right"]$153.25 [/TD]
[/TR]
[TR]
[TD="class: xl68"]$950.00 [/TD]
[TD="class: xl65"]8[/TD]
[TD="class: xl67"]($50.76)[/TD]
[TD="class: xl69, align: right"]$153.25 [/TD]
[/TR]
[TR]
[TD="class: xl68"]$173.00 [/TD]
[TD="class: xl65"]1[/TD]
[TD="class: xl66"]$0[/TD]
[TD="class: xl69, align: right"]$153.25 [/TD]
[/TR]
[TR]
[TD="class: xl68"]$268.00 [/TD]
[TD="class: xl65"]2[/TD]
[TD="class: xl66"]$0[/TD]
[TD="class: xl69, align: right"]$153.25 [/TD]
[/TR]
[TR]
[TD="class: xl68"]$95.00 [/TD]
[TD="class: xl65"]1[/TD]
[TD="class: xl67"]($31.27)[/TD]
[TD="class: xl69, align: right"]$153.25 [/TD]
[/TR]
[TR]
[TD="class: xl68"]$231.00 [/TD]
[TD="class: xl65"]1[/TD]
[TD="class: xl66"]$0[/TD]
[TD="class: xl69, align: right"]$153.25 [/TD]
[/TR]
</tbody>[/TABLE]

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.