» Nesting OR & AND Functions to Meet Multiple Criteria
CATEGORY - Logical Formulas
VERSION - All Microsoft Excel Versions
We want to create a formula that returns "1" if Num1=10 and either Num2=5 or Num3=2.
Otherwise, the formula is to return "0".
Solution:
Use the IF, AND, and OR functions as shown in the following formula:
=IF(AND(A2=10,OR(B2=5,C2=2)),1,0)
Book Store:
Recommended Books:
- Accounting Principles, with CD, 6th Edition
- The Accounting Game : Basic Accounting Fresh from the Lemonade Stand
- Special Edition Using Microsoft Excel 2002
- Accounting for Dummies
- The McGraw-Hill Guide to Writing a High-Impact Business Plan: A Proven Blueprint for First-Time Entrepreneurs
- Personal Finance for Dummies
No comments have been submitted.
Excel Formula and Function
Excel Date and Time
Excel Macros and VBA
Excel Text, Editing and Format
Excel General
Excel Data
