What does the AND function in Excel do?

Answer 1

The AND function is one of the logical functions in Excel. It used when testing more that one condition to see if all of these are true. So if you were testing for something like is someone earning over a certain amount of money and paying a certain tax rate, you would need the AND function, in conjunction with an IF function to help you achieve this. By itself it returns TRUE or FALSE. Only if all the tests are true does it return TRUE. The following one checks if 10 is less than 5 and is 6 less than 20. Obviously they are, so the function will return a TRUE value.

=AND(10>5,6<20)

The following one checks if 20 is less than 15 and is 60 more than 42. Obviously only one of those things is the case, so the function will return a FALSE value, as both must be true.

=AND(20<15,60>42)

Both of those are simple and obvious examples, but often you will be using values in cells which may or may not meet the conditions and could give different results.

=AND(A3>40,B3<10)