IF(AND)

In Excel, to test if a value meets two conditions and assign them values accordingly, you can use the If(AND) function. In other words, If condition 1 and condition 2 are true, you can use this formula to assign them a new value of x, or if they’re false, y.