jeudi 29 août 2019

Is there a function to check the same value in range?

I am using google sheets and I have a query that if the value in the range is the same then write something. If at least value is other from rest. Can somebody have an idea how to bite this topic?

I was trying to use

=if(A2:C2="Something";"YES";"NO")


=if(A2="Something" AND B2="Something";"YES";"NO")

Aucun commentaire:

Enregistrer un commentaire