Data Table shows one incorrect value

I am a long time excel user and have never encountered this bizarre problem before. I have a simple, one-variable vertical data table with 4 rows of hard coded values to measure the sensitivity of the outcome of the model result. Very simple. However, the result in the last row of the data table does not match the actual calculated value in the model if I manually change the variable in the model to match. The prior three rows match the model result exactly when I manually changed this one variable in the model. This is bizarre.
I attached a picture here of the same simple data table copy and pasted with values for 4 iterations of it where I manually changed the model input variable to test how the outcome of the model measures up against the results of the data table. I changed nothing else. Because the data table shown in the picture, all the other inputs and outcomes are literally the same. To be more specific, the "Model Result" in line 173 should match the color coded cell in the data table below it.
How can this happen? Happy to provide more info if you can help out. I cannot send the entire spreadsheet as I am under an NDA. Hopefully this explanation with the attached picture is enough to provide a full explanation of the problem. Thanks in advance. excel problem 1.png

Hard to say without the data.

What is the formula that is in BA173?

the formula is the exact same formulas as the formula in cells AR173, AU173 and AX173. These are the "pasted values" of the same data table where I manually changed the model inputs So really this shows the same data table 4 times - it is all the same formulas. Does that make sense?

Not to me.

Can you attach just the sheet that contains the data in the image?

Unfortunately I really cannot - the sheet is part of a massive confidential financial model under an NDA so not sure how to separate it out. I will try to explain more … I ran this simple data table one time using the "Model Result" output cell shown in cell AR173 which is the output cell that drives the data table below it in columns AQ and AR. For the data table column input cell, I entered the single cell in the entire model (cell E4) which drives the percentage in the model. I hard coded the data table to run 4 scenarios (50%, 60%, 70% and 80%). The data table shows those 4 lines of results (0.7139, 0.9310, 1.1537, and 1.3453). So on a whim I decided just to check it the model manually. The model started with "50%" in cell E4. I then manually entered "60%" in cell E4 and noticed the resulting model output matched the result in the data table (0.9310). Then I manually entered "70%" in cell E4 and noticed the resulting model output matched the result in the data table (1.1537). Then, in a bizarre twist, I changed nothing else in the model and only entered "80%" in cell E4 and noticed the resulting model output did NOT in fact match the result of the data table (as I showed in my picture). How is this theoretically possible?

Thanks for your replies. That is not quite right. Unfortunately this is not a simple algebra problem. The output cell is the result of a large financial model. I will try to change my explanation a little so perhaps it is easier to see the problem. I will attached 4 pictures and go through it.
Iteration 1: Base case with model input of 50%
excel problem 2-50.png
Notice that the prediction in the in the data table in line 173 matches the model output in line 172

Iteration 2: Change except but the model input to 60%
excel problem 3-60.png
Notice that the prediction in the in the data table in line 174 matches the model output in line 172

Iteration 3: Change nothing except the model input to 70%
excel problem 4-70.png
Notice that the prediction in the in the data table in line 175 matches the model output in line 172

Iteration 4: Change nothing but the model input to 80%
excel problem 5-80.png
Notice that the prediction in the in the data table in line 176 DOES NOT MATCH the model output in line 172. How is this logically possibly? I have changed nothing else in the model. As you can see, it references the same output cell each time. The data table prediction results theoretically calculate the output cell from the same set of formulas that the data table. Since the first 3 predictive lines of the data table match the model output, how is it possible that the final predictive result doesn't match the model output when the formulas haven't changed?