Creating Complex Formulas
If we wanted to add the contents of cell B2 and cell B3, for example, and then take that answer and multiply it by the data in cell A4, then we would need to define the following formula: =(B2+B3)*A4.
- Enter the numbers you want to calculate.
- Click the cell where you want the formula result to appear.
- Type the equal sign (=) to let Excel know a formula is being defined.
- Type an open parenthesis, or (
- Click on the first cell to be included in the formula (cell B2, for example).
- Type the addition sign (+) to let Excel know that an add operation is to be performed.
- Click on the second cell in the formula. The reference B3 displays where you want your result.
- End the B2+B3 operation by adding the close parenthesis, or )
- Type the next mathematical operator, or the multiplication symbol (*) to let Excel know that an multiply operation is to be performed.
- Click on the third cell to be included in the formula, cell A4.
- Very Important: Press Enter or click the Enter button on the Formula bar. This step ends the formula.
0 Response to "Creating Complex Formulas"
Post a Comment