Monday, 20 February 2012

Creating Complex Formulas

Excel 2003 automatically follows a standard order of operations in a complex formula. If you want a certain portion of the formula to be calculated first, put it in parentheses.
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 Enter button on the Formula bar. This step ends the formula.
Try changing one of the values in the formula and watch the answer to the formula change.


Post a Comment