» Simplifying Formulas by Reducing the Complexity of IF Functions
CATEGORY - Excel Array Formulas
VERSION - All Microsoft Excel Versions
Problem: The range A2:A4 lists the three primary colors.
To find which of the various colors in column B are primary colors, we could use the following IF formula:
=IF(OR(B2=A2,B2=A3,B2=A4),"Primary Color","Not a Primary Color").
However, such a formula would become increasingly complex as the number of values in column A increases.
Solution:
Use the IF and OR functions as shown in the following Array formula:
{=IF(OR(B2=$A$2:$A$4),"Primary Color","Not a Primary Color")}
Book Store:
Recommended Books:
- Special Edition Using Microsoft Outlook 2002
- Treason: Liberal Treachery from the Cold War to the War on Terrorism
- Business Analysis and Valuation: Using Financial Statements, Text and Cases
- Financial Statement Analysis: A Practitioner's Guide, 3rd Edition
- Microsoft Office Xp: Advanced Concepts and Techniques: Word 2002, Excel 2002, Access 2002, Powerpoint 2002
- Microsoft Excel Version 2002 Step by Step
No comments have been submitted.
