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)

Aucun commentaire:
Enregistrer un commentaire