The free guide

AND function in Excel

Use

Tests number of logical conditions set by a user, like you can highlight all those numeric values which are less than 150 and greater than 100.

Description

The Excel AND function either returns:

  • TRUE if logical conditions are met

Or

  • FALSE if logical conditions are not met.

Syntax

=AND (logical1, [logical2], …)

logical1 – It is the first logical condition to test.

[logical2] – It is the optional argument, used as second logical condition.

Example

Formulas:

Results:

 

Copyright © 2016 - 2017 Explainry.com | All Rights Reserved