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>
 

Excel Facts

Get help while writing formula
Click the italics "fx" icon to the left of the formula bar to open the Functions Arguments dialog. Help is displayed for each argument.
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?
 
Upvote 0
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:
Upvote 0
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.
 
Upvote 0

Forum statistics

Threads
1,213,489
Messages
6,113,949
Members
448,534
Latest member
benefuexx

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top