Forum Discussion
Excel_Building_Eng50
Jun 06, 2019Copper Contributor
Formulas returning nonsensical results
I recently had a few formulas start returning nonsensical results and am at a total loss. For example, a formula that takes the max of (0.095, 0.095, 0.2995, 0.2995) is returning 0.7787. When I 'F9' the max formula cell it returns the correct value. I've attached screenshots showing this. Has anybody else experienced this or know how to correct this?
Thanks in advance for your help.
11 Replies
- Excel_Building_Eng50Copper Contributor
Also, yes, I've ensured that calculations are turned on.
- SergeiBaklanDiamond Contributor
- Excel_Building_Eng50Copper Contributor
SergeiBaklan , yes calculations are automatic.