Need Help? Chat with us

Excel Logical functions – AND, OR

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



Special Offer for First Time Users

If you are the first time user and want to learn Microsoft office skills, then you can avail this special offer discount on your email.

PIvot table Webinar payment Code

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.

Learn 100+ Excel Tips & Tricks



“To be an Excel Superstar”

Special Offer for First Time Users

If you are the first time user and want to learn Microsoft office skills, then you can avail this special offer discount on your email.

PIvot table Webinar payment Code

Download ebook