vendredi 9 août 2019

Use ranges in if statements

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