Microsoft Office Tutorials and References
In Depth Information
Creating and Editing Formulas
Table 11-2 Arithmetic Operators Supported in Excel Formulas
+ (plus sign)
Addition (=14+7, =C4+C5). If one of the values is negative, the
result is the same as subtraction.
– (minus sign)
Subtraction (=17–3, =D1–D2) or negation (=–6, =–A7).
Multiplication (=3*10, =B5*B6).
/ (forward slash)
Division (=24/8, =B5/C5). The elements on either side of the
operator are the dividend and the divisor, respectively. If the
divisor evaluates to zero, you get a #DIV/0! error.
% (percent sign)
Percent (=10%, =A1%). The result is the same as dividing
the number by 100; typically used with multiplication, as in
=10%*42, which results in 4.2
Exponentiation (=3^2, =C4^D8). Multiplies the number to the
left of the operator by itself the number of times specified by
the number to the right of the operator
When you use any of the arithmetic operators, the constants, references, functions, or
formulas on both sides of the operator must result in values. If your formula is =C4+C5 or
=D1*C5 and C5 is a text string, your result is the same: a #VALUE! error.
INSIDE OUT Keyboard shortcuts for formulas
For touch typists who think moving one’s hands away from the keyboard is a surrender
to the forces of chaos and anarchy, we offer these productivity-salvaging keyboard
Ctrl+` (The character shown is an accent grave, typically found beneath the tilde
at the left of the number row on a standard PC keyboard.) This shortcut alternates
between displaying cell values and displaying formulas in the worksheet and offers a
useful way to see a worksheet’s logic at a glance.
Ctrl+' (The character shown is an apostrophe, typically found to the left of the Enter
key on a standard PC keyboard.) Use this shortcut to copy a formula from the cell
above into the active cell.
Ctrl+A Enter an equal sign, followed by any function name, and then press this
keyboard shortcut to open the Function Arguments dialog box
Ctrl+Shift+A Enter an equal sign, followed by any function name, and then press this
keyboard shortcut to insert the argument names and parentheses.