vendredi 6 novembre 2015

If Statement giving value error

I am trying to compare two data ranges to determine if they are the same or not.

I'm using the following statement and I get a #Value! error message:

=IF(SUM(ABS(B2:E7-G2:J7))=0,"Same", "Not")

Aucun commentaire:

Enregistrer un commentaire