Formula that includes < and +

General FAQs
1

Hello, wanted to create a column for scoring/rating, in respective way:

each employee that has equal or more than 90 of Accuracy of the menu - score 1, between 80 and 89.99 - score 2, between 70 and 79.99 - score 3. Used this formula down, but it doesn’t include when the accuracy of the menu is 90/80/70, but just if accuracy is higher (>) or lower (<). How in this formula we can also include equal (=)?

IF({Accuracy of the menu (%)}>90,1,IF(AND({Accuracy of the menu (%)}<89.99,{Accuracy of the menu (%)}>80),2,IF(AND({Accuracy of the menu (%)}<79.99,{Accuracy of the menu (%)}>70),3)))

2

@Jan2

Try:

IF({Accuracy of the menu (%)}>=90, 1,
   IF({Accuracy of the menu (%)}>=80, 2, 
      IF({Accuracy of the menu (%)}>=70, 3, "")))