CATEGORY: Logical Formulas 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 cell 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)}

Rate this tip 1 2 3 4 5   RATING: 2.90   VIEWS: 35792 Email Tip Print Tip Add to My Tips

READER COMMENTS (view all comments)

No comments have been submitted.

REGISTERED USERS - Click here to post comments GUESTS (Click here to register) Name Comment Title Comments

The Essential 55: An Award-Winning Educator's Rules for Discovering the Successful Student in Every Child The Interpretation of Financial Statements Windows XP for Dummies Harry Potter and the Order of the Phoenix (Book 5) Analysis of Financial Statements The 22 Immutable Laws of Branding

RELATED MICROSOFT EXCEL TIPS

Create User Forms in Microsoft Excel Using Loops in VBA in Microsoft Excel The Best Shortcut Keys in Microsoft Excel Writing Your First VBA Function in Excel Add Combo Box to a Sheet in Microsoft Excel Formulas to calculate Loan payments in Microsoft Excel Array variables using VBA in Microsoft Excel Create an Amortization Schedule in Microsoft Excel Find duplicates items in combine columns in Microsoft Excel Vlookup Formula – Organizing the Data Table

• Excel VBA books
• Accounting books
• Business Plans
• MS Office books
• Taxes books