# Excel OR Function

## OR Function

The OR function is a premade function in Excel, which returns TRUE or FALSE based on two or more conditions.

It is typed `=OR`.

Note: The OR function is often used together with the IF function.

=OR([logical1], [logical2], ...)

The conditions are referred to as `[logical1]`, `[logical2]`, and so on.

The conditions can check things like:

• If a number is greater than another number `>`
• If a number is smaller than another number `<`
• If a number or text is equal to something `=`

Note: The different parts of the function are separated by a symbol, like comma `,` or semicolon `;`

The symbol depends on your Language Settings.

## Example OR Function

Check if the Pokemon type is water OR has defense greater than 60:

The function returns "TRUE" or "FALSE".

Example OR function, step by step:

1. Select the cell `D2`
2. Type `=OR`
3. Double click the OR command

1. Specify the first condition `B2="Water"`
2. Type `,`
3. Specify the second condition `C2>60`
4. Hit enter

Note: You can add more conditions by repeating steps 5-6 before hitting enter.

Since the value in cell `B2` is not "Water" the first condition is FALSE.

Since the value in cell `C2` is less than 60 the second condition is also FALSE.

At least one condition need to be TRUE for the OR function to return TRUE.

Note: Text values needs to be in quotes: " "

The function can be repeated with the filling function for each row to perform the same check for each Pokemon:

Now, each row has a check for Water Type or Defense greater than 60:

For example:

• Ivysaur is not Water type, but it has more than 60 defense, so the function returns "TRUE".
• Charmeleon is not Water type, and has less than 60 defense, so the function returns "FALSE"
• Wartortle is both Water type and has more than 60 defense, so the function returns "TRUE"

## Example OR Function (with IF)

Combining the OR function with an IF function lets you check multiple conditions for the IF function:

Note: The IF function lets you specify the return values.

The IF function is typed `=IF` and has 3 parts:

=IF(logical_test, [value_if_true], [value_if_false])

The OR function takes the place of the `logical_test` condition.

Here, the IF function returns "Yes" or "No".

Example OR function as the condition for IF function, step by step:

1. Select cell `D2`
2. Type `=IF`
3. Double click the IF command

1. Type `OR`
2. Double click the OR command

1. Specify the first condition `B2="Water"`
2. Type `,`
3. Specify the second condition `C2>60`
4. Type `),`
5. Specify the value `"Yes"` for when either or both conditions are TRUE
6. Type `,`
7. Specify the value `"No"` for when both conditions are FALSE
8. Type `)` and hit enter

The function can be repeated with the filling function for each row to perform the same check for each Pokemon:

Now, each row has a check for Water Type or Defense greater than 60:

For example:

• Ivysaur is not Water type, but it has more than 60 defense, so the function returns "Yes".
• Charmeleon is not Water type, and has less than 60 defense, so the function returns "No"
• Wartortle is both Water type and has more than 60 defense, so the function returns "Yes"

×

## Contact Sales

If you want to use W3Schools services as an educational institution, team or enterprise, send us an e-mail:
sales@w3schools.com