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))
|
Multiple functions
Vivian06 wrote on October 04, 2005 15:06 EST |
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 wrote on December 31, 1969 19:00 EST |
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 wrote on December 31, 1969 19:00 EST |
| Andrew, this would be a good place to use VLOOKUP. |
|
PowerPoint® 2002 For Dummies®
