Excel AND Function

Excel AND Function
© Ted French

The AND function is another of Excel's Logical Functions. In general, a logical function only gives you a true or false answer. It evaluates the data in a spreadsheet cell to see if that data meets the specified criteria. If it does, the function returns a True response in the cell where the function is located. If not, a False statement is returned.

The AND function allows you to specify up to 255 criteria to be evaluated. All of these criteria would need to meet the specified criteria for the function to give you a True response.

As with the OR function, the AND function, by itself, has limited usefulness. When by combining it with another function, such as the IF function, the AND function can greatly increase the capabilities of your spreadsheet.

To find out how to use this function, read this short article on the Excel AND Function.

Related Articles

• Excel 2003 AND Function
• Excel OR Function
• Excel IF Functions