Forum Discussion

_K_O_'s avatar
_K_O_
Copper Contributor
Mar 30, 2020

Unexpected result from new calc engine using IF, INDIRECT, ROW

So I got more unexpected results with the new calculation engine.   See formulas 1, 2, and 3 below with commentary.  You can get the same results as I get if you use the Evaluate Formula (Data ribb...
excel
Formulas and Functions
JKPieterse's avatar
JKPieterse
Silver Contributor
Mar 31, 2020
I have notified the Excel team about this.
_K_O_'s avatar
_K_O_
Copper Contributor
Mar 31, 2020

Thanks JKPieterse 

 

I also reported it via the 😞 within Excel.

  • JKPieterse's avatar
    JKPieterse
    Silver Contributor
    Mar 31, 2020
    There should be an update soon that fixes this.