The AND function is rarely used independently, but is often used to extend the usefulness of functions that perform logical tests such as the IF function. The following article will guide you how to use the AND function through specific examples.
Syntax: =AND(logical1, [logical2],…)
The AND function syntax has the following arguments:
- logical1 – the first condition that you want to evaluate for TRUE or FALSE.
- [logical2] – (Optional) This is the second condition that you want to evaluate for TRUE or FALSE.
1.1 Syntax: =AND(A1>10,A1<100)
1.2 Syntax: =AND(A2>10,A2<100)
The AND function is very simple and has a great application in calculating. You can use this function along with other logical test functions to calculate and statistic more efficiently on Excel spreadsheets.