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.
