Excel AND and OR
https://www.powerupbusiness.net/training
The AND function returns TRUE if all its arguments evaluate to TRUE, and returns FALSE if one or more arguments evaluate to FALSE. One common use for the AND function is to expand the usefulness of other functions that perform logical tests.
Formula: =AND(logical1,[logical2]…)
The OR function in Excel is a logical formula that tests multiple conditions to determine if any of them are true. If at least one of the conditions is true, the function yields "TRUE." The result is "FALSE" if all the conditions are false.
Formula: =OR(logical1, [logical2], …)