To perform this task, you might use theIF functionin combination with theAND function.
AND function
TheAND functionreturns TRUE if all arguments are TRUE.
For that reason, the text values in the logical test are left in lowercase.
If either condition isn’t true, the AND function will return FALSE.
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.
