The AND function returns TRUE if all its arguments evaluate to TRUE, and returns FALSE if one or more arguments evaluate to FALSE.. One common use for the AND function is to expand the usefulness of other functions that perform logical tests. For example, the IF function performs a logical test and then returns one value if the test evaluates to TRUE and another value if the test evaluates to ...

IFS function (Microsoft 365, Excel 2016 and later) Overview of formulas in Excel. How to avoid broken formulas. Detect errors in formulas. Statistical functions. Excel functions (alphabetical) Excel functions (by Category)