Microsoft Office Tutorials and References

In Depth Information

Find

PRODUCTS AND SQUARE ROOTS

Many Excel users are familiar with the basic

operations available by clicking the AutoSum button:

addition, subtraction, minimum, maximum, and

count. Fewer are familiar with two other basic

operations available by using a mathematical

function. Using the
PRODUCT
function, you can

multiply two or more numbers, and using the
SQRT

function, you can find the square root of a number.

Excel can calculate the square roots of positive

numbers only. If a negative number is the argument,

as in
SQRT(–1)
, Excel returns #NUM in the cell.

You can compute a
PRODUCT
or
SQRT
by entering the

values to be used in the function into the worksheet.

If you do not want the values to appear in the

worksheet, start by clicking in the cell where the

result is to appear and pressing an equal sign (=),

typing the function name —
PRODUCT
or
SQRT
— and

parentheses. Click the Insert Function button (fx) to

enter your values for the formula.

C
ALCULATE A
P
RODUCT

1
Type the values you want to

multiply.

2
Click in the cell in which you

want the result to appear.

3
Type
=product(
in the cell.

Note:
Typing the function directly

into a cell or into the formula bar

preceded by an equal sign is an

alternative to choosing it from the

Function Wizard.

4
Click the Insert Function button.

l
The Function Arguments dialog

box appears.

5
Click the cell address of the first

value you want to multiply or

type the cell address.

Optionally, you can type a value

directly into the Number1 field.

6
Click the cell address of the

second value you want to

multiply or type the cell address.

Optionally, you can type the

value directly into the Number2

field.

l
The Function Arguments dialog

box displays the interim answer.

7
Click OK.

l
The product appears in the cell

you clicked in Step 2.

4

1

2

3

5

6

7

46