I’m currently trying to create the following range formula in Monday. It works correctly in Excel but not in Monday. Do you wonderful people have any ideas on how I might achieve this.

If less than 1.7 enter Low in the cell, if between or equal to 1.8 and 2.3 then enter Medium, or if the score is between 2.4 and 3 enter High. If the value is greater than 3.1 then rate Very High.

NOTE: I replaced the E2 with {Value Score} in Monday.

=IF(AND(E2>=0, E2<=1.7), “Low”,IF(AND(E2>=1.8, E2<=2.3), “Medium”, IF(AND(E2>=2.4, E2<=3),“High”, IF(AND(E2>=3.1),“Very High”, 0))))