8+ Or 関数使い方 For You

条件で結果を分けるIF関数｜スプレッドシートの使い方 from spread-sheets.com

Introduction

If you’re an avid Excel user, you’ve probably encountered situations where you need to evaluate multiple conditions at the same time. This is where the OR function comes in handy. The OR function in Excel allows you to check if any of the given conditions are true. In this tutorial, we’ll explore how to use the OR function in Excel.

Syntax of the OR Function

The syntax of the OR function is quite simple. It takes one or more arguments and returns TRUE if any of the arguments are TRUE. Here’s the syntax of the OR function:

=OR(logical1, [logical2], …)

Where logical1, logical2, … are the conditions that you want to evaluate.

Using the OR Function with Multiple Conditions

Let’s take an example where we want to check if a student has passed in either English or Math. We can use the OR function to check if either of the conditions is true. Here’s how the formula would look like:

=OR(D2>=60, E2>=60)

Where D2 and E2 are the cells containing the marks for English and Math, respectively. If either of the conditions is true, the OR function will return TRUE.

Using the OR Function in Nested Formulas

The OR function can also be used in nested formulas. Let’s say we want to check if a student has passed in either English or Math, and also if the total marks are greater than 150. Here’s how the formula would look like:

=IF(OR(D2>=60, E2>=60), IF(SUM(D2:E2)>150, "Pass", "Fail"), "Fail")

In this formula, we’ve nested the OR function inside an IF function. If either of the conditions is true, the IF function will check if the total marks are greater than 150. If the total marks are greater than 150, the student will pass; otherwise, they will fail.

Using the OR Function with Other Functions

The OR function can also be used with other functions like SUM, AVERAGE, etc. Let’s say we want to calculate the average marks of all the students who have passed in either English or Math. Here’s how the formula would look like:

=AVERAGEIF(OR(D2:D10>=60, E2:E10>=60), TRUE, F2:F10)

In this formula, we’ve used the OR function inside the AVERAGEIF function. The AVERAGEIF function calculates the average of the marks in column F, for all the rows where either of the conditions in column D or E is true.

Conclusion

The OR function is a powerful tool that can be used to evaluate multiple conditions in Excel. We’ve covered the basic syntax of the OR function, how to use it with multiple conditions, in nested formulas, and with other functions like AVERAGEIF. With this knowledge, you should be able to use the OR function effectively in your Excel spreadsheets.