Excel: Or Function

In Excel, the Or function returns TRUE if any of the conditions are TRUE. Otherwise, it returns FALSE.

The syntax for the Or function is:

Or( condition1, condition2, ... )

condition is something that you want to test that can either be TRUE or FALSE. There can be up to 30 conditions.

Applies To:

For example:

Let's take a look at an example:

Based on the Excel spreadsheet above:

=Or(A1<10, A1=40) would return FALSE.

=Or(A1=30, A2="Microsoft") would return TRUE.

=Or(A1>=5, A1=20, A2="Tech on the Net") would return TRUE.