How to use the AND function

In Excel, the AND function is a logical function that tests whether all the supplied conditions are true or not. It takes one or more arguments as inputs and returns TRUE if all of the arguments are evaluated as TRUE, and FALSE if any of the arguments are evaluated as FALSE.

Where logical1, logical2, … are one or more expressions that you want to evaluate.

This formula would return TRUE only if both B3 is greater than 150 and C3 is less than 250. If either condition is not met, the formula would return FALSE.

You can use the AND function with other functions like IF, SUMIF, COUNTIF, etc. to apply multiple conditions in a single formula.