Show-Me  Academy Menu  |  FAQ  |  About  |  Contact  |  See all the latest video tutorials from Show-Me Academy with our RSS feed

Show me how to create custom formulas in Microsoft Excel 2007

Excel -> Microsoft Excel 2007

Problem: I need for certain cells to be automatically calculated based upon the values that exist in other cells.



  1. Open Microsoft Excel 2007
  2. Select a cell and type "="
  3. Type the coordinates for another cell containing data (e.g., "D9" or "H3" or "B22")
  4. Type an operand (e.g., "+" or "-" or "*" or "/")
  5. Type the coordinates for another cell containing data (e.g., "D9" or "H3" or "B22"), or type a numerical value (e.g., "5" or "12.2" or "-9")
  6. Click the "Enter" key

Menu  |  FAQ  |  About  |  Contact  |  Terms  |  Privacy  |  RSS
© Copyright 2008 by Show-Me Academy, Inc. - All rights reserved