Lists all Excel functions by their category, such as Logical functions or Text functions.

Returns an array of random numbers between 0 and 1. However, you can specify the number of rows and columns to fill, minimum and maximum values, and whether to return whole numbers …

Common functions that could return multi-cell ranges include INDEX, OFFSET, and User Defined Functions (UDFs). A common exception is if they are wrapped in a function that accepts an …

You can create a function for a commonly used formula, eliminate the need to copy and paste this formula (which can be error-prone), and effectively add your own functions to the native Excel …

Be sure to include a $ symbol before B and before 2 in the formula, and press ENTER. Note: Using $ symbols tells Excel that the reference to B2 is "absolute," which means that when you …

It includes trigonometric, statistical, and financial functions, as well as conditional, date, math, and text formulas. If you don't see what you are trying to do here, see if you can do it in Excel. …

Learn these top skills to create your own formulas and functions.

A custom function must start with a Function statement and end with an End Function statement. In addition to the function name, the Function statement usually specifies one or more …

You can define a name for a cell range, function, constant, or table. Once you adopt the practice of using names in your workbook, you can easily update, audit, and manage these names.

The structure of a function begins with an equal sign (=), followed by the function name, an opening parenthesis, the arguments for the function separated by commas, and a closing …

Or press Ctrl+F to find a function by typing the first few letters or a descriptive word. To get detailed information about a function, click its name in the first column.