Formulas and Functions

Gain comprehensive knowledge on over 300 Excel formulas and functions, covering both worksheet functions entered in the formula bar and VBA functions utilized in Macros. Expand your understanding of Excel’s capabilities and enhance your proficiency.

Here is a categorized list of Excel formulas. If you prefer an alphabetical arrangement of these formulas, Click on the button below.

Lookup/Ref Functions:

ADDRESSTo obtain the address of a worksheet in Excel. ADDRESS function is used. You must give the specific row and column number to locate the cell.
VLOOKUPVLOOKUP is also a function used in MS Excel. When you want to search for any specific data in your Excel worksheet, this function is used.
ROWSWhen you want the number of rows in a particular range, then Excel provides you the ease to find it through the ROWS function.
TRANSPOSEThe main purpose of the TRANSPOSE function is to rotate or switch the orientation of cells within a particular range.
XLOOKUPXLOOKUP function in MS Excel is like an upgraded form of the previous LOOKUP, VLOOKUP, and HLOOKUP functions.
RowThe ROW function in Excel is used to return the number of the row of the given reference. It is a worksheet function of Excel. It is a built-in function in Excel.
OFFSETThe OFFSET function is used to return a specific number of rows and columns. We get the return value of column or row numbers from a particular cell or range of cells.
IndirectThe purpose of the INDIRECT function in Excel is to return the reference to a range with the help of a given text string.
LOOKUPThe LOOKUP function in Excel is a very famous function because it is sued to solve some specific problems in Excel. It works as a worksheet function in Excel.
MATCHThe MATCH function in Excel is used to find a specific item in a range of cells. Then the position of that item is shown as a returned value.
INDEXThe purpose of this function in Excel is to return a value from a specific cell or range of cells within a table or array. 
HYPERLINKThe purpose of the HYPERLINK function in MS Excel is to jump to a different location. It can jump to a location in the current workbook.
HLOOKUPThe purpose of the HLOOKUP function in Excel is to retrieve data from a row in a table or array. It searches for the given value in the first row of the table. 
COLUMNThe COLUMN function in Excel is more like a reference/ lookup function in Excel. It is used to give a reference to a specific column in a table or cell reference.
COLUMNSThe purpose of this function is to calculate the total number of columns in a reference array or range of cells.
CHOOSEThe purpose of the CHOOSE function in Excel is to get the value from a specific list by specifically mentioning the position of the value in the list.
AREASA number of areas in a given reference are returned with the help of the AREAS function in MS Excel. 


ANDThe purpose of AND function in Excel is to return a value after testing multiple conditions.
FALSEThe FALSE function in MS Excel is used as a logical function. It is a sub-category of logical functions in Excel.
IFThis is a very popular and easy-to-use function in MS Excel. This function is a logical function that is used to make a logical comparison between two values.
IFERRORThe IFERROR function in MS Excel is used to find the errors in formulas.
IFNAThe main purpose of the IFNA function in MS Excel is to track and manage the #N/A errors.
XORThe XOR function is the acronym for Exclusive OR. This is a premade function in MS Excel. It is used to return a logical value.
SWITCHThe SWITCH function comes under the category of logical functions in MS Excel. It is used to evaluate a value or an expression against a list of expressions or values.
TRUEThis is used to return a TRUE value as the result. This is used as the Boolean logical value TRUE. It is used in a condition where you want the returned value to be TRUE.
NOTThis is a logical function. The Not function in MS Excel is used to test the logical conditions. It is also known as a reverse logical function.
ORThe OR function in MS Excel is used to test if the condition is TRUE or FALSE.
IFSThe IFS function in Excel is able to perform multiple tests on different values. It returns the result value when the value is TRUE. 
Scroll to top