- Understanding Formulas and Cell References in Excel
- Creating Simple Cell Formulas
- Assigning Names to Groups of Cells
- Using Names in Formulas
- Creating a Formula That References Values in an Excel Table
- Creating Formulas That Reference Cells in Other Workbooks
- Summing a Group of Cells Without Using a Formula
- Creating a Summary Formula
- Summing with Subtotals and Grand Totals
- Exploring the Excel Function Library
- Using the IF Function
- Checking Formula References
- Debugging Your Formulas
Creating Simple Cell Formulas
Building calculations in Excel is pretty straightforward. If you want to find the sum of the values in two cells, you just type an equal sign (=), the reference of the first cell, a plus sign (+), and the reference of the second cell. The formula you enter appears on the formula bar, where you can examine and edit it.
Build a Formula
Click the cell in which you want to enter a formula.
Type the expression representing the calculation you want to perform.
Edit a Formula
Click the cell you want to edit.
Select the part of the formula you want to edit in the formula bar.
Make any changes that you want.