Logical & Reference Functions in Microsoft Excel

Excel Formulas > Logical & Reference Functions

Logical & Reference Functions in Excel are used to perform logical tests or work with data using its reference. These are by far the most useful and powerful functions in excel. Examples are, counting number of cells in a range that match a particular condition, testing several logical conditions for operations like AND, OR etc. Here is a list of most frequently used logical & reference formulas in excel.

And() MS Excel Formula
Countblank() MS Excel Formula
Countif() MS Excel Formula
If() MS Excel Formula
Large() MS Excel Formula
Max() MS Excel Formula
Min() MS Excel Formula
Not() MS Excel Formula
Or() MS Excel Formula
Small() MS Excel Formula
Sumif() MS Excel Formula
Vlookup() MS Excel Formula

Other types of Excel Formulas