IF + AND“IF + AND” formulas are used to test if a value meets multiple criteria, giving one result, otherwise giving another.
IF + ORLearn how to use "IF + OR" formulas: if the value is x OR y, THEN a, ELSE b when you have more than one criteria.