Forum Discussion
Excel returning incorrect result even though evaluation gives the correct result
The spreadsheet is posting an incorrect result, Even though when I run evaluate formula the final result inside its popup is correct, when finished a different result is posted to the spreadsheet
9 Replies
Spoke too soon the reinstall did not correct the problem.
I attached the sheet ,,, look at cells AO7:AO16 for example though it occurs in other places, IN particular AO11 and AO12. Running evaluate formula leads to a different result which is correct
Dichotomy66 Wow, what a schedule. For an outsider like myself, the formulae are difficult to grasp without a thorough analysis of the entire workbook. When I opened the schedule I got a warning that it contained circular references. Not a good sign. Then I evaluated the formula in AO11 and noted a large number of #VALUE! errors, and after about a hundred clicks it returned 0.00, exactly what is in AO11. So, I'm afraid I'm not the right person to help you here. Sorry!
Yeah it is an extremely complex sheet for sure Riny_van_Eekelen
And for some reason every now and then it will go from working fine for months to suddenly getting a bug. Fortunately I know the sheet well enough that usually I can fix them quickly.
Dichotomy66 Would be helpful if we could see the formula, the expected outcome and the result it produces.
It is not a formula issue as this is happening in a few different places on the spreadsheet. As I said the "evaluate formula" returns the correct answer as its final result but the spreadsheet then posts a different result. This spreadsheet and all its formulas has worked fine for a year or more with no changes. Then in the last few days it stopped working correctly
Is calculation set to 'Manual'?
