OR Function in Excel

In this post, let’s look at one of the logical functional called OR Function in excel and how you can use them effectively in your spreadsheet.

What is the use of the OR Function in excel?

The OR function is a logical function to test multiple conditions at the same time. OR returns either TRUE or FALSE value.

The following steps will explain the work of OR Function in excel:

  • First, prepare an excel sheet with the required details in it.
How to use Logical OR Function in Microsoft Excel ?
  • To check the condition, you can use the OR Function formula: =OR(B2>70,C2=100).
How to use Logical OR Function in Microsoft Excel ?

OR Function

  • The IF statement is a decision-making statement that guides a program to make decisions based on specified criteria. It executes one set of code if a specified condition is met (TRUE) or another set of code evaluates to FALSE.
  • To use the OR Function in combination with the IF function, you can follow the given formula: =IF(OR(B2>70,C2=100),”Pass”,”Fail”).
How to use Logical OR Function in Microsoft Excel ?
  • The AND Function returns TRUE if all conditions are true and returns FALSE if any of the conditions are false.
  • To use the OR Function in combination with the And function, you can follow the given formula: =AND(A2=”Table”,OR(B2=”Green”,B2=”Blue”)).
How to use Logical OR Function in Microsoft Excel ?
Subscribe to Blog via Email

Enter your email address to subscribe to this blog and receive notifications of new posts by email.

Hey, wait!Subscribe to Blog via Email

Enter your email address to subscribe to this blog and receive notifications of new posts by email.