The IF statement can be used in combination with the AND statement. The AND statement allows you to look at multiple conditions instead of just one like the regular IF statement. Example: =IF(AND(VariableA=Value,VariableB=Value),TRUE,FALSE) This formula is saying that if VariableA is TRUE and VariableB is TRUE, then the formula will evaluate to the TRUE value. Otherwise if either VariableA or VariableB are FALSE, then the return value will be FALSE. An IF AND formula is asking that ALL variables be TRUE to return the TRUE value. It only takes one FALSE variable to render the value as FALSE.
The IF statement can be used in combination with the AND statement. The AND statement allows you to look at multiple conditions instead of just one like the regular IF statement.
Example: =IF(AND(VariableA=Value,VariableB=Value),TRUE,FALSE)
This formula is saying that if VariableA is TRUE and VariableB is TRUE, then the formula will evaluate to the TRUE value. Otherwise if either VariableA or VariableB are FALSE, then the return value will be FALSE. An IF AND formula is asking that ALL variables be TRUE to return the TRUE value. It only takes one FALSE variable to render the value as FALSE.