OR Formula in Excel

 

What Does It Do?

This function tests two or more conditions to see if any of them are true.

It can be used to test that at least one of a series of numbers meets certain conditions.

Normally the OR() function would be used in conjunction with a function such as =IF().

Syntax

=OR(Test1,Test2)

Note that there can be up to 30 possible tests.

Formatting

When used by itself it will show TRUE or FALSE.

Example

The following table shows a list of orders taken by a company.

A handling charge of £5 is made on all orders paid by Visa or Delta cards.

The =OR() function has been used to determine whether the charge needs to be applied.