https://bugs.documentfoundation.org/show_bug.cgi?id=170788
--- Comment #3 from [email protected] --- Updated sample to reproduce: (changed AVERAGE range only) Active, 3, 4, 5, =IF(A1<>"Active","N/A",LET(avg, AVERAGE(B1:D1), IF(avg>=4, "Great", IF(avg>=3, "Good", "Poor")))) -- You are receiving this mail because: You are the assignee for the bug.
