IF + AND“IF + AND” formulas are used to test if a value meets multiple criteria, giving one result, otherwise giving another.
If Only...If only this is x, then it’s y. Read on to find out how to apply "IF" formulas to your data.