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...
excel
Formulas and Functions
Excel_Building_Eng50's avatar
Excel_Building_Eng50
Copper Contributor
Jun 06, 2019

Also, yes, I've ensured that calculations are turned on.

SergeiBaklan's avatar
SergeiBaklan
Diamond Contributor
Jun 06, 2019

Excel_Building_Eng50 , do you mean under "calculations turned on" what they are in automatic mode?

 

    • Zack Barresse's avatar
      Zack Barresse
      Iron Contributor
      Jun 06, 2019
      Can you upload your file please? I'm unable to reproduce.

      You might try the Evaluate Formula feature on the Formulas tab.

Resources