jeudi 16 mai 2019

How can I ignore or address blank cells in an Excel function?

I have 7 columns and I want to check if each value in the columns are the same. However, each column does not have a value. I would like to create a function that says:

=IF("A = B = C = D = F = I = J", Value of the cells, False) However, I want to ignore any blank cells, so it does not trigger a False.

Aucun commentaire:

Enregistrer un commentaire