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