In this release:

  • Fix: a Conditional Rule with a whole-number value (for example "Element value is greater than 2") compared decimal cell values with 0 instead of the value, so 0.4 or 1.1 were highlighted as greater than 2. Equal to, not equal to, greater/less than (or equal to), between and not between now compare decimal cells correctly.
  • Fix: in "Formula result value is true" rules, SUMIFS and AVERAGEIFS with two or more condition pairs, for example SUMIFS(Table1.C2:C20, Table1.A2:A20, "East", Table1.B2:B20, "Open"), showed "Index 2 out of bounds" or returned a wrong result. Both functions now check every condition on the same row, as in Excel.