What it does: The OR() checks if at least one condition you listed is TRUE.
Plain English: The OR() function is similar to the AND() function in that we’re testing a list of criteria. However, the OR() function equates to TRUE if any of the criteria are TRUE. The AND() function is only TRUE if ALL criteria are met.
If you’re analyzing offensive players in football, perhaps you want to narrow down your selection to only those players averaging at least 1 touchdown per game OR at least 100 avg. yards per game. With the OR() statement, you can do so.
Arguments: OR(TEST1, TEST2, etc..)
- TEST 1 – The first thing you want to test, i.e. Averaging at least 1 touchdown per game – FALSE
- TEST 2 – The second thing you want to test, i.e. Averaging at least 100 yards per game – TRUE
NOTE: If any condition within the OR() statement equates to TRUE, the entire statement is TRUE.