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
 
Search JabSto ::




Custom Search