Excel Logical functions – AND, OR

AND Functions:-
AND(logical1, [logical2], …)

The AND function syntax has the following arguments:

logical1 Required. The first condition that you want to test that can evaluate to either TRUE or FALSE.

logical2, … Optional. Additional conditions that you want to test that can evaluate to either TRUE or FALSE, up to a maximum of 255 conditions.

OR Functions:-
OR(logical1, [logical2], …)

The OR function syntax has the following arguments:

Logical1, logical2, … Logical1 is required, subsequent logical values are optional. 1 to 255 conditions you want to test that can be either TRUE or FALSE.