Math and trigonometry
ROUNDUP Function
Rounds a number away from zero
by
Charley Kyd, MBA Microsoft Excel MVP, 20052014
The Father of Spreadsheet Dashboard Reports

Syntax
ROUNDUP(number, num_digits)
 number Required. Any real number that you want to rounded towards zero.
 num_digits Required. The number of digits to which you want to round the number.
Applies To
Excel 2003 and above
A Note About
"Rounding"
In Excel, numbers can "round" in two ways.
First, they can round up or down. With this type of rounding,
numbers
get larger when they are rounded up, and smaller when they are
rounded down.
Second, numbers can round towards zero or away from zero.
When positive numbers are rounded towards zero, they get
smaller; when negative numbers are rounded towards zero, they get larger.
Although Microsoft uses "round up" and "round down" to
describe both types of rounding, we use "round up" or "round
down" to describe the first type of rounding. And we use "round
towards zero" or "round away from zero" to describe the second
type.
Remarks
 ROUNDUP works like ROUND, except that it always rounds a number
away from zero.
 If num_digits is greater than 0 (zero), then number
is
rounded up (away from zero) to the specified number of decimal places.
 If num_digits is 0, then number is rounded up
(away from zero) to the nearest integer.
 If num_digits is less than 0, then number is rounded
up (away from zero) to
the left of the decimal point.
Examples
You can
download this example workbook here,
along with all other example workbooks I've completed for this
Excel help area.
Other ExcelUser
Information
Other Help
