The OR operate is a logical operate in Microsoft Excel, and its function 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-compulsory.
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.
Launch Excel.
Create a desk or use an current desk.
Within the desk within the picture 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 =OR(B2>50, C2>50).
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.
Methodology one is to click on the fx button on the highest left of the excel worksheet.
An Insert Operate dialog field will seem.
Contained in the dialog field within the part, Choose a Class, choose Logical from the record field.
Within the part Choose a Operate, select the OR operate from the record.
Then click on OK.
A Operate 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.
Methodology two is to click on the Formulation tab and click on the Logical button within the Operate Library group.
Within the record, click on OR.
A Operate Arguments dialog field will seem.
Comply with the steps in technique one for Operate Arguments.
We hope this tutorial helps you perceive the way to use the OR operate in Excel.
Learn subsequent: add or sum Time in Excel.
