Microsoft Office Tutorials and References
In Depth Information
ROUNDDOWN
ROUNDDOWN
The ROUNDDOWN function rounds a number down, toward zero.
=ROUNDDOWN(number, digits)
ROUNDDOWN behaves like ROUND , except that it always rounds a number down.
If digits is greater than 0 (zero), then number is rounded down to the specified number of
decimal places. If digits is 0 or omitted, then number is rounded down to the nearest integer.
If digits is less than 0, then number is rounded down to the left of the decimal point. For
example: ROUNDDOWN(10.3, 0) equals 10.
The NUMBER argument is any real number that you want rounded
down.
NUMBER
The DIGITS argument is the number of digits to which you want
to round number.
DIGITS
ROUNDUP
The ROUNDUP function rounds a number up, away from 0 (zero).
=ROUNDUP(number, digits)
ROUNDUP behaves like ROUND , except that it always rounds a number up.
If digits is greater than 0 (zero), then number is rounded up to the specified number of
decimal places. If digits is 0 or omitted, then number is rounded up to the nearest integer. If
digits is less than 0, then number is rounded up to the left of the decimal point. For example:
ROUNDUP(9.4,0) equals 10.
The NUMBER argument is any real number that you want rounded up.
NUMBER
The DIGITS argument is the number of digits to which you want
to round number.
DIGITS
SERIESSUM
The SERIESSUM function returns the sum of a power series that uses the following formula:
SERIES(x,n,m,a) = a 1 x n + a 2 x (n+m) + a 3 x (n+2m) +...+ a i x (n+(i-1)m)
This function is available from the Analysis ToolPak under Tools, Add-Ins in the menu if the
box for that add-in is checked. If it is not in the add-in list, run Setup to install it.
The X argument is the input value to the power series.
X
The N argument is the initial power to which you want to raise X .
N
The M argument is the step by which to increase N for each term
in the series.
M
Search JabSto ::

Custom Search