The CELL function returns information about the formatting, location, or contents of a cell. For example, if you want to verify that a cell contains a numeric value instead of text before you …

Use VLOOKUP, HLOOKUP, and other functions like INDEX and MATCH to search for and find data based on values you enter. This article gives you a quick VLOOKUP refresher, then links …

Functions are predefined formulas that perform calculations by using specific values, called arguments, in a particular order, or structure. Functions can be used to perform simple or …

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.

The implicit intersection operator (@) may return a value, single cell range, or an error. The implicit intersection operator (@) is in a class of functions called dynamic arrays.

When you create a simple formula or a formula by that uses a function, you can refer to data in worksheet cells by including cell references in the formula arguments.

Learn how to insert the filename or path of an Excel spreadsheet or a specific worksheet in a cell.

You can create a formula to calculate values in your worksheet by using a function. For example, the formulas =SUM (A1:A2) and SUM (A1,A2) both use the SUM function to add the values in …

This new dynamic array behavior can also affect earlier functions that have the ability to return a multi-cell range or array. Below is a list of functions that could return multi-cell ranges or arrays …

Master the art of Excel formulas with our comprehensive guide. Learn how to perform calculations, manipulate cell contents, and test conditions with ease.

You can convert formulas to their values on either a cell-by-cell basis or convert an entire range at once. Important: Make sure you examine the impact of replacing a formula with its results, …