|  

» Nesting OR & AND Functions to Meet Multiple Criteria

Problem:

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))


Rate This Tip
12 34 5
Rating: 3.32     Views: 18077
Multiple functions
Vivian06
Hi, to anyone with knowledge more than me.
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.
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.
Click here to post comment
For Registered Users
Name
Comment Title
Comments