IF + AND“IF + AND” formulas are used to test if a value meets multiple criteria, giving one result, otherwise giving another.