» Simplifying Formulas by Reducing the Complexity of IF Functions
CATEGORY - Excel Formula and Function
VERSION - All Microsoft Excel Versions
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.
Solution 1:
Use the following formula:
=($A$2>D1)+($A$3>D1)+($A$4>D1)>0
Solution 2:
Use the OR function as shown in the following Array formula:
{=OR($A$2:$A$4>D1)}
List1
8
2
3
Number to Compare: 20

Book Store:
Recommended Books:
- The Intelligent Investor: The Classic Bestseller on Value Investing
- The Analysis and Use of Financial Statements
- Excel 2002 For Dummies®
- Seven Habits Of Highly Effective People
- Preparing the Marketing Plan (Ama Marketing Toolbox Series New Edition)
- Keys to Reading an Annual Report (Barron's Business Keys)
swatsp0p
Per the example given, I believe the reference "...number in List1 larger than the value in E16." should actually state D1, not E16.
if function
ahmad ganjian
How do I use if statement with odd or even number. For instance, I was to say, if such a cell has even number in it, do this, otherwise, do something else.

