P:\IT&L\Technology Training\Office2007\Excel\Formulas.docx 1 Entering Formulas in Excel 2007 Add, divide, multiply, and subtract Type an equal sign (=), use a math operator … … and then press ENTER.=10+5 to add=10-5 to subtract=10*5 to multiply=10/5 to divide Formulas are visible in the formula bar when you click a cell that contains a result. If the formula bar is not visible, on the View tab on the Ribbon, in the Show/Hide group, select the Formula Bar check box. Use cell references in formulas Entering cell …

Formulas are visible in the formula bar when you click a cell that contains a result. If the formula bar is not visible, on the View tab on the Ribbon, in the Show/Hide group, select the Formula Bar check box. Use cell references in formulas Entering cell references lets Microsoft® Excel® automatically update formula results if cell values are changed. For example: Type =C4+C7 in a cell. Or type the equal sign (=), click cell C4, type the plus sign (+), and then click cell C7. Cell references Refer to values in A10 the cell in column A and row 10 A10,A20 cell A10 and cell A20 A10:A20 the range of cells in column A and rows 10 through 20 B15:E15 the range of cells in row 15 and columns B through E A10:E20 the range of cells in columns A through E and rows 10 through 20 Note: If results are not updated, on the Formulas tab, in the Calculation group, click Calculation Options. Then click Automatic. Add the values in a row or column Use the SUM function, which is a prewritten formula, to add all the values in a row or column: 1. Click a cell below the column of values or to the right of the row of values. 2. On the Home tab, in the Editing group, click the Sum button , and then press ENTER. Tip: The Sum button is also located on the Formulas tab, in the Function Library group. To add some of the values in a column or row: 1. Type an equal sign, type SUM, and then type an opening parenthesis. 2. Type or select the cell references you want to add. A comma (,) separates individual arguments that tell the function what to calculate. 3. Type a closing parenthesis, and then press ENTER. For example: =SUM(B2:B4,B6) and =SUM(B2,B5,B7)

Download Entering Formulas in Excel 2007 Add, divide, multiply, and subtract.Pdf