» Simplifying Formulas by Reducing the Complexity of IF Functions
CATEGORY - Excel Formula and Function
VERSION - All Microsoft Excel Versions
Problem: 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 Complete Book of Business Plans: Simple Steps to Writing a Powerful Business Plan (Small Business Sourcebooks)
- The 22 Immutable Laws of Branding
- Business Analysis and Valuation: Using Financial Statements, Text and Cases
- Microsoft Access Version 2002 Step by Step
- Microsoft Outlook 2002 for Dummies
- Absolute Beginner's Guide to Microsoft Office Excel 2003
No comments have been submitted.

