• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 3. Building Basic Formulas > Using Arithmetic Formulas

Using Arithmetic Formulas

Arithmetic formulas are by far the most common type of formula. They combine numbers, cell addresses, and function results with mathematical operators to perform calculations. Table 3.1 summarizes the mathematical operators used in arithmetic formulas.

Table 3.1. The Arithmetic Operators
OperatorNameExampleResult
+Addition=10+515
Subtraction=10-55
Negation=-10–10
*Multiplication=10*550
/Division=10/52
%Percentage=10%0.1
^Exponentiation=10^5100000


Most of these operators are straightforward, but the exponentiation operator might require further explanation. The formula =x^y means that the value x is raised to the power y. For example, the formula =3^2 produces the result 9 (that is, 3*3=9). Similarly, the formula =2^4 produces 16 (that is, 2*2*2*2=16).

  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint