In this article, you will learn what the OR formula is and how to use it in Google Sheets.
The OR formula returns “TRUE” when one or more inputs are logically true, and the OR function provides “FALSE” if no argument is logically true. So, unless none of the arguments are logically false, the formula returns “TRUE”.
The general formula is as below:
Logical_expression1: You need to insert a logical test such as “A1=1”, ”A1<B1”, and “A1+B1=2” by manually input and/or cell reference.
Logical_expression2 (Optional): You can add more than one expression if needed.
Note: The number 0 is considered logically “FALSE” by the OR function; all other numbers (including negative numbers) are considered logically “TRUE”.
The following screenshot shows examples of the usage of the OR function.
The OR function is often combined with the IF function rather than used alone. As the OR formula returns “TRUE” or “FALSE”, the OR and the IF function, which needs “TRUE” or “FALSE” input to determine which value to show, go well together.
Assume that you are a manager and need to check whether your group members have test results that meet at least one of the following criteria.
The formula shown in the picture above contains the OR function containing the arguments below:
Logical_expression1: C15>=$C$10 (Test A Score 54>=70) → Unmet
Logical_expression2: D15>=$C$11 (Test B Score 67>=70) → Unmet
Logical_expression3: E15>=$C$12 (Total Test Score 121>=140) → Unmet
As for the formula in cell F15, the OR function returns “FALSE as all requirements are unmet”. Therefore, the IF function returns the defined value of “No”, the value provided when it is false.
Check this article if you want to learn about different types of references.
Tiger fails to pass these exams because it doesn’t meet any criteria.
If you don’t get the right answer to your question in this article or you have other questions on logic formulas, you may find the answers in the following articles.
Should you need to learn about the IF or IFS formulas, check the following articles.
If you want to learn about how to use the AND formula, visit the web page below.
Are you interested in what a tick box is and how to use it? Read the following post.
Are you learning this formula to build a financial model or financial KPI dashboard, or conduct financial analysis? If so, LiveFlow may help you to automate manual workflows and keep numbers updated in real time. For instance, you can easily compare your Budget versus Actual without any manual work. Furthermore, you can access other templates here, from the simple Income Statement and Operational KPI templates to Multi-Currency Consolidated Income Statement, Balance Sheet, and Cash Flow templates. You can also customize these templates as you want without breaking the automated data inflow.
To learn more about LiveFlow, book a demo.
Learn how to do this step-by-step in the video below 👇