Microsoft Office Tutorials and References
In Depth Information
Using Excel Functions
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.
Converting a value to Roman numerals.
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.