Microsoft Office Tutorials and References

In Depth Information

**Creating and Editing Formulas**

Table 11-2 Arithmetic Operators Supported in Excel Formulas

Operator

Usage

+ (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).

* (asterisk)

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

^ (caret)

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

shortcuts:

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.