» Simplifying Formulas by Reducing the Complexity of IF Functions
We want to create a conditional formula that will return TRUE if there is at least one number in List1 greater than the value in D1. Otherwise the formula will return FALSE.
Use the following formula:
Use the OR function as shown in the following Array formula:
Number to Compare: 20
|Screenshot // Simplifying Formulas by Reducing the Complexity of IF Functions |