» 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:
- Microsoft Windows XP Inside Out
- Final Accounting: Ambition, Greed and the Fall of Arthur Andersen
- Financial Reporting and Analysis (2nd Edition)
- Microsoft Word Version 2002 Step By Step (With CD-ROM)
- The McGraw-Hill 36-Hour Course in Finance for Nonfinancial Managers
- Managing by the Numbers: A Commonsense Guide to Understanding and Using Your Company's Financials: An Essential Resource for Growing Businesses
No comments have been submitted.
