OR

See also A-Z Spreadsheet Function List

Description Returns True if at least one of a series of logical arguments is true.

Syntax OR(logical_list)

logical_list is a list of conditions separated by commas. You can include as many as 30 conditions in the list. The list can contain logical values or a reference to a range containing logical values. Text and empty cells are ignored. If there are no logical values in the list, the error value #VALUE! is returned.

See Also AND , IF , and NOT functions

Example OR(1 + 1 = 1, 5 + 5 = 10) returns True because one of the arguments is true.