Forum Discussion

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

Microsoft

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_

Copper Contributor

Mar 31, 2020

Thanks Andy_Becker