Microsoft Excel AND Function

Using AND With IF

The AND and OR functions allow you to group together conditions or values in conjunction with an IF statement in order to adjust the way your IF determines it’s value. For instance, Figure 1 shows the use of an AND function with an IF statement:

Figure 1

AND with IF …

In this example, we’re using an AND formula to help round out the condition in our IF statement. We’re asking the function to make sure that BOTH the sum of A1 and A2 AND the sum of A3 and A4, respectively, total less than 90. Since A3 plus A4 equals 128, our condition evaluates to FALSE, and thus the word “Over” is returned.

Can this be done without using an AND formula? Yes, and it would look like Figure 2:

Figure 2

Same Function - No "AND"

As you can see, it’s more cumbersome to use nested IF statements when you can easily use an AND function to define your calculation clearly – it’s what they’re there for!

David Badurina, President of Blue Moose Technology, LLC, is a relational database design expert. David's unique ability to easily explain virtually any technical concept has allowed him to work with companies such as AMD, Motorola, the American Heart Association, and countless small businesses. Learn more about database design right now at http://www.bluemoosetech.com.

Article Publishing and Re-Print Guidelines

The article text, resource box, URLs copyright information and these guidelines must be left intact and unchanged.
When re-published online, all links must be live hyperlinks.
These articles may not be distributed in any manner that does not comply with federal communication guidelines. Be Good!
These articles must not be password protected or limited to membership or paid-only viewing. Keep 'em free, folks!

You can easily link to this article!

If you'd like to link to this article from your own website, copy and paste the following HTML code onto your page:

On your page, the code will appear like this:

Microsoft Excel AND Function