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.
The Excel AND function either returns:
- TRUE if logical conditions are met
- FALSE if logical conditions are not met.
=AND (logical1, [logical2], …)
logical1 – It is the first logical condition to test.
[logical2] – It is the optional argument, used as second logical condition.