Hi Teacher!
This guide to rounding functions (and those associated to them) is
extracted from my Functions lists Word and Excel files, free to good
homes on private request by e-mail.
With each function be sure that you address what you want to happen to
negative numbers and that you appreciate the number line concept
whereby numbers may be regarded as being positioned on a horizontal
line ranging from infinitely large negative numbers on the left,
through 0 to infinitely large numbers on the right. Thus if a
description below talks in terms of rounding away from zero, negative
numbers are rounded to the left and positive to the right on the
number line.
CEILING(number,significance):
Rounds a number (away from zero) to the nearest multiple of
significance.
EVEN(number):
Rounds a number (away from zero) to the nearest even integer.
FLOOR(number,significance):
Rounds a number (towards zero) to the nearest multiple of
significance.
INT(number):
Rounds a number to the left on a number line. (Positive rounded
towards 0, Negative rounded away from zero.)
ISEVEN(number):
Returns TRUE if a number is even. (Analysis ToolPak required).
ISODD(number):
Returns FALSE if a number is odd. (Analysis ToolPak required).
MOD(number,divisor):
Returns the remainder from division with the result having the same
sign as
the divisor.
MROUND(number,multiple):
Returns a number rounded to the desired multiple. Midway points are
rounded
away from 0. (Analysis ToolPak required).
ODD(number):
Rounds a number away from zero to the nearest odd integer.
QUOTIENT(numerator,denominator):
Returns the integer portion of a division.
ROUND(number,num_digits):
Rounds a number to a specified number of digits to the left (-) or
right (+)
of the decimal point. The midway digit 5 is rounded away from 0.
ROUNDDOWN(number,num_digits):
Rounds a number down towards 0 to a specified number of digits to the
left
(-) or right (+) of the decimal point.
ROUNDUP(number,num_digits):
Rounds a number up away from 0 to a specified number of digits to the
left
(-) or right (+) of the decimal point.
TRUNC(number,[num_digits]):
Truncates a number to an integer or to specified precision by removing
the
fractional part of the number. (Serves to round down towards 0)
--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
