lundi 31 juillet 2017

NESTED IF AND STATEMENTS

I think I've made a mistake as it keeps returning #VALUE.

IF(AND(G2="green",G3="green"),"GG"),IF(AND(G2="red",G3="red"),"RR") ,IF(AND(G2="red",G3="green"),"RG") ,IF(AND(G2="green",G3="red"),"GR")

I'm trying to say if it is red and it is green, print RG and others such as RR,GR,GG.

Aucun commentaire:

Enregistrer un commentaire