Use the AND function

The AND function is a logical function that tests multiple conditions.

=AND(A1>25,A1<75) returns TRUE if the value of A1 is greater than 25, or less than 75.

=AND(A1="Yes",B1="Yes") returns TRUE if A1 contains the text "Yes" and B1 also contains "Yes".

In these examples, the formula displays TRUE if all of the conditions are satisfied, and FALSE if even one condition isn't satisfied.

The AND function is a logical function that tests multiple conditions.

=AND(A1>25,A1<75) returns TRUE if the value of A1 is greater than 25, or less than 75.

=AND(A1="Yes",B1="Yes") returns TRUE if A1 contains the text "Yes" and B1 also contains "Yes".

In these examples, the formula displays TRUE if all of the conditions are satisfied, and FALSE if even one condition isn't satisfied.

The AND function is a logical function that tests multiple conditions.

=AND(A1>25,A1<75) returns TRUE if the value of A1 is greater than 25, or less than 75.

=AND(A1="Yes",B1="Yes") returns TRUE if A1 contains the text "Yes" and B1 also contains "Yes".

In these examples, the formula displays TRUE if all of the conditions are satisfied, and FALSE if even one condition isn't satisfied.