Forum Discussion

_K_O_'s avatar
_K_O_
Copper Contributor
Mar 31, 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
Andy_Becker's avatar
Andy_Becker
Icon for Microsoft rankMicrosoft
Mar 31, 2020

Hi _K_O_,

 

Thanks for bringing this to our attention!  We're investigating the issue and should have more to share soon.

 

Andy

Microsoft

  • _K_O_'s avatar
    _K_O_
    Copper Contributor
    Mar 31, 2020

    Thanks Andy_Becker 

Resources