In my sheet I have 2 seperate rows for example, and I want to compare them to eachother. If i wanted to do it the long way this is what it would look like:
=IF(AND(A1>B1, A2>B2 ect), "true", "false")
I want to be able to do it in a range like this:
=IF(A1:A50>B1:50, "true", "false")
What is a simple way to do this?
Aucun commentaire:
Enregistrer un commentaire