EXCEL OR FUNCTION

The EXCEL OR function in Microsoft Excel is a logical function that returns TRUE if any of the specified conditions or expressions are TRUE, and it returns FALSE if all of them are FALSE.

Syntax:

=OR(logical1,[logical2],…..)

Arguments or Parameters

logical1: first condition given.
logical2: second condition given.

Objective: Find AL or MI State code in the given range.

Step 1:

Type = sign in E2 cell
Type OR Function

Step 2:

Column D2 refers to Experience.
logical1 : D2 = “AL”
Type “,”

Step 3:

logical2: D2=”MI”
Close bracket with “)”
Press Enter

Result: OR Function has given True to all the cells in range E2:E20 where the State code is AL or State code is MI.