jeudi 20 mai 2021

Do I need to use a ELIF function for a nested IF function

I'm trying out this nested IF function in google docs: =IF(AA2<0.2,0,IF(0.2<=AA2<0.4,1,IF(0.4<=AA2<0.6,2,IF(0.6<=AA2<0.8,2,IF(0.8<=AA2<=1,3,"WRONG")))))

However when the function is used on values such as 0.432, or 0.8, it automatically shows me the "WRONG" value. How can I correct this?

enter image description here

Aucun commentaire:

Enregistrer un commentaire