mercredi 22 avril 2020

IF AND OR statement not computing correctly

I am having some trouble with my if statement, join with and and or. Could someone tell me why the selected cell is not returning the value of 2? It returns "" even though it is between 6.5 and 6.0. The other problem I am running into is when I format column R to have one decimal place, the selected cell should result in 1.

Column S equation: =IF(AND(R2<=H2+0.5,R2>=H2-0.5),1,"")

Column U equation: =IF(OR(S2=1,T2=2),"",3)

enter image description here

Aucun commentaire:

Enregistrer un commentaire