Type a function name (or terms associated with the function, such as “address”) in the search field at the top of the Functions Browser, or browse the available functions, then double-click the name of the function you want. You can resize it by dragging from any of its outer edges. For help with a function, click it.ĭrag the left side of the formula editor to move it. The formula editor opens, and the Functions Browser appears on the right side of the window, displaying a list of all the functions. If the message indicates another cell is causing the error, you can click the cell reference to select the cell with the error.Ĭlick the cell where you want the result of the function to appear, then type the equal sign (=).
If there’s an error in your formula, appears in the result cell. If you click, you exit the formula editor without saving your changes. Press Return or click in the formula editor when you’re done. Type an arithmetic operator (for example, +, -, *, or /), then select a cell to use as the next argument in your formula, or type a value.īy default, + is inserted between cell references.Ĭontinue adding arguments and operators until your formula is complete. You can resize it by dragging from any of its outer edges.Ĭlick the cell to use as the first argument in your formula, or type a value (for example, a number such as 0 or 5.20). Drag the left side of the formula editor to move it. You can create simple or complex arithmetic formulas to perform calculations on the values in your tables.Ĭlick the cell where you want the result to appear, then type the equal sign (=).
0 kommentar(er)
