The OR operate is a logical operate in Microsoft Excel, and its goal is to find out if any situation you check is True. The system for the OR operate is OR (logical1, [logical2],..). The Syntax for the OR operate is:
- Logical 1: The primary logical worth to judge. It’s required.
- Logical 2: The second worth to judge. It’s non-obligatory.
Find out how to use Excel OR operate
To make use of the OR operate in Microsoft Excel to find out if a situation is True, comply with the steps under:
- Launch Excel
- Create a desk or use an current desk.
- Enter the system OR (logical1,[logical2])
- Press the Enter Key
- See End result.
Create a desk or use an current desk.
Within the desk within the photograph above, we wish to decide who fails and who passes the exams.
Enter the system into the cell the place you wish to place the consequence
Press Enter on the keyboard to see the consequence and drag the fill deal with right down to see the consequence for the others.
There are two different strategies to make use of the OR operate in Excel.
Technique one is to click on the fx button on the highest left of the excel worksheet.
An Insert Perform dialog field will seem.
Contained in the dialog field within the part, Choose a Class, choose Logical from the listing field.
Within the part Choose a Perform, select the OR operate from the listing.
Then click on OK.
A Perform Arguments dialog field will open.
- Within the Logial1 part, enter into the field the cell B2>50.
- Within the Logical2 part, enter into the field the cell C2>50.
Then click on OK to see the consequence.
Technique two is to click on the Formulation tab and click on the Logical button within the Perform Library group.
Within the listing, click on OR.
A Perform Arguments dialog field will seem.
Comply with the steps in technique one for Perform Arguments.
We hope this tutorial helps you perceive use the OR operate in Excel.
Learn subsequent: Find out how to add or sum Time in Excel.