Types of Cell References

When writing formulas, Excel allows Relative, Absolute, and Mixed references.

Relative Reference

• Adjusts automatically when formula is copied to another cell
  

• Default behavior
  

• Copied to B2 → Formula becomes =A2+A3 automatically
  

Use: Most formulas where pattern repeats across rows/columns.

Absolute Reference

• Fixed reference using $ symbol
  

• Does not change when copied
  

Syntax:

• $C$1 is fixed
  

• When copied down, always multiplies by C1
  

Use: When multiplying all rows by a fixed rate, e.g., Tax, Discount.

Mixed Reference

• Part of reference is fixed, part changes
  

• $A1 → Column fixed, row changes
  

• A$1 → Row fixed, column changes
  

Use:

• Creating multiplication tables
  

• Dynamic charts or lookup calculations

Writing & Editing Formulas

Writing Formulas

1. Start with =
   

2. Select cell(s) or type values
   

3. Use operators:
   

• + Addition
  

• - Subtraction
  

• * Multiplication
  

• / Division
  

• ^ Exponent
  

Example:

Editing Formulas

• Select the cell → Formula Bar → Edit
  

• Press F2 to edit in-cell
  

• Use arrow keys or mouse to change cell references
  

Tip: Use Tab to auto-complete function names (e.g., SUM, AVERAGE).

Formula Errors & Troubleshooting

Common Errors

Troubleshooting Tips

Check parentheses ()
Verify cell references
Use Trace Precedents / Dependents → Formulas Tab
Use Evaluate Formula → Step-by-step calculation
Avoid hardcoding numbers in formulas

Practical Example

• Copy formula down using fill handle
  

• $C$2 is absolute → same tax rate for all rows
  

• A2 & B2 are relative → changes per row