» 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:
- Good to Great: Why Some Companies Make the Leap... and Others Don't
- Microsoft Excel 2002 Visual Basic for Applications Step by Step
- Successful Business Planning in 30 Days: A Step-By-Step Guide for Writing a Business Plan and Starting Your Own Business
- Windows XP All-in-One Desk Reference For Dummies
- Special Edition Using Microsoft Outlook 2002
- H&R Block's Just Plain Smart(tm) Tax Planning Advisor: A year-round approach to lowering your taxes this year, next year and beyond
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.
