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

Which lookup functions find a value equal or greater than the lookup value?
MATCH uses -1 to find larger value (lookup table must be sorted ZA). XLOOKUP uses 1 to find values greater and does not need to be sorted.

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,114,513
Messages
5,548,499
Members
410,840
Latest member
Kar3ousse
Top