CATEGORY: Logical Formulas VERSIONS: All Microsoft Excel Versions

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 1 2 3 4 5   RATING: 3.32   VIEWS: 14529 Email Tip Print Tip Add to My Tips

READER COMMENTS (view all comments)

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.

REGISTERED USERS - Click here to post comments GUESTS (Click here to register) Name Comment Title Comments

Rich Dad, Poor Dad: What the Rich Teach Their Kids About Money--That the Poor and Middle Class Do Not! The Analysis and Use of Financial Statements A Mathematician Plays the Stock Market Your First Business Plan: A Simple Question and Answer Format Designed to Help You Write Your Own Plan (3rd Ed) Essentials of Investments with Standard & Poor's Educational Version of Market Insight + PowerWeb + Stock Trak Coupon Managerial Accounting: Tools for Business Decision Making, WebCT, 2nd Edition

RELATED MICROSOFT EXCEL TIPS

Create User Forms in Microsoft Excel Using Loops in VBA in Microsoft Excel The Best Shortcut Keys in Microsoft Excel Writing Your First VBA Function in Excel Add Combo Box to a Sheet in Microsoft Excel Formulas to calculate Loan payments in Microsoft Excel Array variables using VBA in Microsoft Excel Create an Amortization Schedule in Microsoft Excel Find duplicates items in combine columns in Microsoft Excel Vlookup Formula – Organizing the Data Table

• Excel VBA books
• Accounting books
• Business Plans
• MS Office books
• Taxes books