» Nesting OR & AND Functions to Meet Multiple Criteria
CATEGORY - Logical Formulas
VERSION - All Microsoft Excel Versions
We want to check whether or not each value in List1 (column A) meets both of the following criteria:
1. The number must be even.
2. The number must be smaller than 3 or larger than 8.
Solution:
Use the AND, MOD, and OR functions as shown in the following formula:
=AND(MOD(A2,2)=0,OR(A2<3,A2>8))
Book Store:
Recommended Books:
- Final Accounting: Ambition, Greed and the Fall of Arthur Andersen
- Yes, You Can Time the Market!
- Essentials of Investments with Standard & Poor's Educational Version of Market Insight + PowerWeb + Stock Trak Coupon
- Successful Business Planning in 30 Days: A Step-By-Step Guide for Writing a Business Plan and Starting Your Own Business
- Financial Statement Analysis with S&P insert card
- Windows XP Pocket Reference
Adding IF Statements
Andrew
I have 2 "IF" statements with 7 and 5 conditions, respectively. When these statements are in the cell singly, they give me the numerical result I'm expecting, which can be summed. However, when I add the IF statements together using "&" it results in the right answer, but in a text form which I cannot sum. Thanks in advance for any help on this matter.
=IF(T266="Airfield",I266,IF(U266="Landside Operations",I266*'Alloc Pct'!$C$7,IF(U266="Facilities Maintenance",I266*'Alloc Pct'!$C$8,IF(U266="Airport Security",I266*'Alloc Pct'!$C$9,IF(U266="Environmental Affairs",I266*'Alloc Pct'!$C$10,IF(U266="Airport Operations",I266*'Alloc Pct'!$C$11,IF(U266="Facilities Development",I266*'Alloc Pct'!$C$12,"")))))))&IF(U266="Real Estate Management",I266*'Alloc Pct'!$C$13,IF(U266="Airport Planning",I266*'Alloc Pct'!$C$14,IF(U266="Airport System Planning",I266*'Alloc Pct'!$C$15,IF(U266="G & A",I266*'Alloc Pct'!$C$16,""))))
Nested "IF" statements
Judith
Andrew, this would be a good place to use VLOOKUP.
I am trying to create a formula for the day w/the lowest temp. of the month. I cannot just use the Min fxn from a set of cells I have to say on what day of the month is the lowest temp of the month. So I have to create some complex fxn to check both columns at once.
Please help.