Microsoft Office Tutorials and References
In Depth Information
Entering Formulas
2
RIGHT ARROW
key to complete the
arithmetic operation
indicated by the
formula, to display
the result in the
worksheet, and to
select the cell to the
right (Figure 2 – 6). The
number of decimal
places shown in cell F4
may be different, but
these values will be
adjusted later in this
chapter.
Press the
active cell
is G4 after
pressing RIGHT
ARROW key
value of formula
(65.25 × 20.5)
Figure 2–6
Arithmetic Operations
Table 2 – 2 describes multiplication and other valid Excel arithmetic operators.
Table 2 – 2 Summary of Arithmetic Operators
Arithmetic
Operator
Example
of Usage
Meaning
Meaning
Negation
– 78
Negative 78
%
Percentage
=23%
Multiplies 23 by 0.01
^
Exponentiation
=3 ^ 4
Raises 3 to the fourth power
*
Multiplication
=61.5 * C5
Multiplies the contents of cell C5 by 61.5
/
Division
=H3 / H11
Divides the contents of cell H3 by the contents of cell H11
+
Addition
=11 + 9
Adds 11 and 9
Subtraction
=22 – F15
Subtracts the contents of cell F15 from 22
 
Search JabSto ::




Custom Search