Forum Discussion

Excel_Building_Eng50's avatar
Excel_Building_Eng50
Copper Contributor
Jun 06, 2019

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.

 

Resources