# Formula not copying

#### cgendron

##### Board Regular
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

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

Replies
15
Views
471
Replies
14
Views
438
Replies
7
Views
668
Replies
2
Views
241
Replies
2
Views
258