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.
| ADDRESS | To 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. |
| VLOOKUP | VLOOKUP 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. |
| ROWS | When you want the number of rows in a particular range, then Excel provides you the ease to find it through the ROWS function. |
| TRANSPOSE | The main purpose of the TRANSPOSE function is to rotate or switch the orientation of cells within a particular range. |
| XLOOKUP | XLOOKUP function in MS Excel is like an upgraded form of the previous LOOKUP, VLOOKUP, and HLOOKUP functions. |
| Row | The 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. |
| OFFSET | The 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. |
| Indirect | The purpose of the INDIRECT function in Excel is to return the reference to a range with the help of a given text string. |
| LOOKUP | The 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. |
| MATCH | The 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. |
| INDEX | The purpose of this function in Excel is to return a value from a specific cell or range of cells within a table or array. |
| HYPERLINK | The 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. |
| HLOOKUP | The 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. |
| COLUMN | The 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. |
| COLUMNS | The purpose of this function is to calculate the total number of columns in a reference array or range of cells. |
| CHOOSE | The 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. |
| AREAS | A number of areas in a given reference are returned with the help of the AREAS function in MS Excel. |
| AND | The purpose of AND function in Excel is to return a value after testing multiple conditions. |
| FALSE | The FALSE function in MS Excel is used as a logical function. It is a sub-category of logical functions in Excel. |
| IF | This 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. |
| IFERROR | The IFERROR function in MS Excel is used to find the errors in formulas. |
| IFNA | The main purpose of the IFNA function in MS Excel is to track and manage the #N/A errors. |
| XOR | The XOR function is the acronym for Exclusive OR. This is a premade function in MS Excel. It is used to return a logical value. |
| SWITCH | The 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. |
| TRUE | This 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. |
| NOT | This 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. |
| OR | The OR function in MS Excel is used to test if the condition is TRUE or FALSE. |
| IFS | The IFS function in Excel is able to perform multiple tests on different values. It returns the result value when the value is TRUE. |