I'm trying to use the value of a numerical cell to define a text cell with logic.
If cell F2 >= 17 AND <= 18 THEN define as "Preservation Class". I basically need to repeat this 3 more times for 3 more ranges.
Below is what I came up with, which does not work. Can someone take a look and see what I'm doing incorrectly? It says that I have entered too few arguments.
=ifs(F2>=17,f2<=18,"Preservation Class",F2>=14,f2<=16,"Retention Class",F2>=11,f2<=13,"Partial Retention Class",F2>=9,f2<=10,"Modification Class",F2>=0,f2<=8,"Rehabilitation Class")
Aucun commentaire:
Enregistrer un commentaire