Excel: And Function

In Excel, the And function returns TRUE if all conditions are TRUE. It returns FALSE if any of the conditions are FALSE.

The syntax for the And function is:

And( condition1, condition2, ... )

condition is something that you want to test that can either be TRUE or FALSE. There can be up to 30 conditions.

Applies To:

Excel 2007, Excel 2003, Excel XP, Excel 2000

For example:

Let's take a look at an example:

Based on the Excel spreadsheet above:

=And(A1>10, A1<40) would return TRUE

=And(A1=30, A2="Microsoft") would return FALSE

=And(A1>=5, A1<=30, A2="Tech on the Net") would return TRUE

Frequently Asked Questions

Question: I need to translate some Quattro Pro functions to Excel. The #AND# function in Qpro can be placed in the middle of a nest and return a number. For example, @if(.......A1>B1#and#A1<B3,7,0)

What this says is, after some other function, if A1 is greater than B1 and A1 is less than B3, return 7 otherwise 0. How do I get Excel to do this?

Answer: This can be done in Excel by combining the AND function with the IF function like this:

=IF(AND(A1>B1,A1<B3)=TRUE,7,0)