Create Basic Formulas

Formulas are used to calculate answers based on mathematical equations that you create. When creating formulas, you may use:

  • Actual values (=7*5)
  • Cell addresses (=C4 +D4 +B25)
  • A combination of the two (=8*C17)

The equal sign (=) indicates a formula entry. This also ensures that formulas beginning with a cell address are not mistaken for text.

When entering these formulas, the following operators are used: