Excel® 2013 On Demand

Creating a Formula Using Formula AutoComplete

To minimize typing and syntax errors, you can create and edit formulas with Formula AutoComplete. After you type an = (equal sign) and begin typing to start a formula, Excel displays a dynamic drop-down list of valid functions, arguments, defined names, table names, special item specifiers—including [ (open bracket),, (comma), : (colon)—and text string that match the letters you type. An argument is the cell references or values in a formula that contribute to the result. Each function uses function-specific arguments, which may include numeric values, text values, cell references, ranges of cells, and so on.

Enter Items in a Formula Using Formula AutoComplete

Click the cell where you want to enter ...