Microsoft Office Tutorials and References

In Depth Information

**Using Excel Functions**

Chapter 9

Working with Formulas and Functions

which cell you want to round and the

second to tell Excel how many decimal places

you want to display. The syntax is

=ROUND(
cell address or number,num of

digits
). For example, if cell C2 has a value of

27.63578 and you want it rounded to two

decimal places, you would enter

=ROUND(D1,2); then Excel would display

the answer of 27.64. Excel also includes the

ROUNDUP and ROUNDDOWN functions,

which specifically round the answer up or

down the number of digits you specify. See

Figure 9-9 for an example.

POWER:
Raises a number exponentially.

There are two arguments in this function.

The first argument refers to the number (or

cell address) you want to raise and the

second argument is to what power. The syntax

is =POWER(
number or cell, power
). Entering

=POWER(5,3) results in 125.

ROMAN:
Displays the Roman numeral value

of a cell. The syntax is =ROMAN(
number or

cell
). So if in cell B3, you had a value of 17

and in cell B4 you entered =ROMAN(B3), the

result is XVII. Using negative values or values

greater than 3999 results in an error. Figure

9-10 illustrates an example where several

years are converted to Roman numerals.

Figure 9-10

Converting a value to Roman numerals.

Figure 9-9

Rounding a value.

Analyzing with Statistical Functions

Statistical-based functions provide a means for

analysis of data. Statistical analysis helps you

explore, understand, and visualize your data. You

access statistical functions from Formulas>

Function Library>More Functions>Statistical. Here

are just a few of the statistical functions:

SQRT:
Finds the square root of a cell or cell

range total. The syntax is =SQRT(
cell range
).

RAND:
The RAND function simply provides

a random decimal value in a cell. The value

is always greater than 0 but less than 1, and

every time the worksheet recalculates any

other value, the random value changes. The

RAND function has no arguments, so the

syntax is =RAND(). There is also a similar

RANDBETWEEN function that lets you

specify a low and high value range. =RANDBE-

TWEEN(2,50) extracts a random whole

number between 2 and 50.

AVERAGE:
The AVERAGE function finds an

average of a range of values. The syntax for

this function is =AVERAGE(
range of cells or

values to average
). An example might be

=AVERAGE(B7:D7), which would add the

values in the three cells B7, C7, and D7, then

divide that total by three to get the average

value. Figure 9-11 shows the average value

of a range of cells.