To perform this task, you’re free to use theIF functionin combination with theAND functionand theOR function.
AND function
TheAND functionreturns TRUE ifallconditions are TRUE.
OR function
TheOR functionreturns TRUE ifanycondition is TRUE.
For that reason, the text values in the logical test are left in lowercase.
In any other case, the formula will return FALSE.
The formula evaluates the side function first, working outwards.
The OR function returns a result to AND, and the AND function returns the final result.
This is exactly what we need for the logical test inside IF.
The result from IF can be customized as needed.
Technically, thisargumentis optional.
More than one condition can be tested by nesting IF functions.
AND returns TRUEonly if all the conditions are met.
If any conditions are not met, the AND function returns FALSE.
OR returns TRUEif any condition is TRUE.
If all conditions are FALSE, the OR function returns FALSE.
