The IF statement can be used in combination with the OR statement. The OR statement allows you to look at multiple conditions instead of just one like the regular IF statement. Example: =IF(OR(VariableA=Value,VariableB=Value),TRUE,FALSE) This formula is saying that if either VariableA is TRUE or VariableB is TRUE, then the formula will evaluate to the TRUE value. An IF OR formula is asking that only one variables be TRUE to return the TRUE value. Only one variable can be TRUE or all variabes can be TRUE for and IF OR formula to evaluate to the TRUE VALUE. ALL variables would have to be FALSE to return the FALSE value.
The IF statement can be used in combination with the OR statement. The OR statement allows you to look at multiple conditions instead of just one like the regular IF statement.
Example: =IF(OR(VariableA=Value,VariableB=Value),TRUE,FALSE)
This formula is saying that if either VariableA is TRUE or VariableB is TRUE, then the formula will evaluate to the TRUE value. An IF OR formula is asking that only one variables be TRUE to return the TRUE value. Only one variable can be TRUE or all variabes can be TRUE for and IF OR formula to evaluate to the TRUE VALUE. ALL variables would have to be FALSE to return the FALSE value.