Forum Discussion
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...
SergeiBaklan , yes calculations are automatic.
- Can you upload your file please? I'm unable to reproduce.
You might try the Evaluate Formula feature on the Formulas tab.Zack Barresse , SS attached. Error I previously mentioned is on sheet 'CODE'. A similar error is occurring on sheet 'WEBHOLES' in cell F6.
Excel_Building_Eng50 , as soon as I try to calculate something in this sheet (e.g. in any empty cell =1+2) it forwards me to VBA. It gives an error
but that doesn't matter, I guess you have no such error. The point is your VBA code is involved into the sheet recalculation.
