|
» Simplifying Formulas by Reducing the Complexity of IF Functions
CATEGORY: Excel Formula and Function |
VERSIONS: 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 |
| Screenshot // Simplifying Formulas by Reducing the Complexity of IF Functions |
  |
|
RATING:
2.89
VIEWS: 23743 |
||||
swatsp0p wrote on May 16, 2005 16:10 EST
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 wrote on December 31, 1969 19:00 EST
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.
Sponsors:
 |
Book Store:
Recommended Books:
- Financial Statement Analysis: A Practitioner's Guide, 3rd Edition
- Absolute Beginner's Guide to Microsoft Excel 2002
- Special Edition Using Microsoft Excel 2002
- Financial Statement Analysis with S&P insert card
- Positioning: The Battle for Your Mind
- Managing by the Numbers: A Commonsense Guide to Understanding and Using Your Company's Financials: An Essential Resource for Growing Businesses
Related MS EXCEL TIPS:
Terms
and Conditions of use
The applications/code on this site are distributed as is and without warranties
or liability. In no event shall the owner of the copyrights, or the authors
of the applications/code be liable for any loss of profit, any problems
or any damage resulting from the use or evaluation of the applications/code.
