Has Excel made an error in calculations?
Has Excel made an error in calculations?
Examine the red cell value, it should equal 0.8633. The spreadsheet is also producing odd results, see the video here: https://youtu.be/PRl7SJRVrfU I'm applying iterative methods to tackle the problem.
No, it wouldn't. Overclocking doesn't typically lead to serious processing errors unless other issues are present.
If you're not using an overclocked setup then that's likely not the problem. I'm not sure what might be causing the issue either—just a bit of experience with Excel doesn't help much. Overclocking can lead to precision issues, which Prime95 tests for (failed tests happen due to incorrect calculations). For most everyday programs, they can tolerate many errors before it becomes an issue, which is why overclocking works fine there. But server applications, which handle heavy computations, need perfect accuracy, so they can't be overclocked or are calibrated to the overclocked speed.
Check the bottom left corner of your screen for the "calcular" option. Pressing it will enable Excel to refresh all formulas automatically. To set this up, navigate to Options > Formulas > Workbook Calculation > Automatic.
I notice they work well in another cell—it’s strange, but I’ll ask my professor about it.