» Nesting OR & AND Functions to Meet Multiple Criteria
CATEGORY - Logical Formulas
VERSION - All Microsoft Excel Versions
Problem: 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:
- Keys to Reading an Annual Report (Barron's Business Keys)
- Microsoft Windows XP Registry Guide
- Accounting the Easy Way
- Now, Discover Your Strengths
- Business Plans Kit for Dummies (With CD-ROM)
- Your First Business Plan: A Simple Question and Answer Format Designed to Help You Write Your Own Plan (3rd Ed)
No comments have been submitted.

