FORMULAS
Equations used to calculate
values in a cell are called formulas.
Formulas help you automatically add, subtract, multiply, divide,
find averages, and much more. When
you type formulas, you always have to type the equal sign (=) first for
the formula to work. The formula bar is directly below the toolbar in
the worksheet and displays a formula when the cell of a worksheet
contains a formula. You
type in your formulas here. (add more pictures)
Examples of formulas:
|
OPERATOR
|
OPERATION
|
EXAMPLE
|
MEANING
|
|
+
|
Addition
|
B5+C5
|
Adds the values in B5 and
C5
|
|
-
|
Subtraction
|
C8-232
|
Subtracts 232 from the
value in C8
|
|
*
|
Multiplication
|
D4*D5
|
Multiplies the value in
D4 by the value in D5
|
|
/
|
Division
|
E7/4
|
Divides the value in E7
by 4
|
|
^
|
Exponentiation
|
B3^3
|
Raises the value in B3 to
the third power
|
