mardi 9 février 2021

I have some problem with this excel formula =IF(A2:J2=O2,"Yes","No")

I am testing this if condition to whether O2 cell is matching with an element in A2:J2. But the formula is displaying in the other 10 cells.
How can I get rid of this issue and execute the formula in only one cell?

Aucun commentaire:

Enregistrer un commentaire