I wrote a formula which was working properly until I added some additional records to the table. Now the formula calculates correctly, but at the last step it rewrites the answer to match the result of the copied cell. This is the formula:

Here is the correct calculated result (after stepping thru the evaluation. Note the number is still underlined):

But then it seems to have an additional step, which results in changing the results:

My calculation is set to automatic and I have tried F9 but the result does not change.
Any ideas/suggestions?

Here is the correct calculated result (after stepping thru the evaluation. Note the number is still underlined):

But then it seems to have an additional step, which results in changing the results:

My calculation is set to automatic and I have tried F9 but the result does not change.
Any ideas/suggestions?