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