Microsoft Office Tutorials and References
In Depth Information
round a monetar y amount down to the nearest cent. Notice the example in Figure 10.15.
If A1 contains $46.234 then =FLOOR(A1,.01) returns $46.23.
The value you want to round.
The multiple to which to round the value to.
Use the FLOOR
function to round values to
the nearest multiple.
GCD The GCD function returns the greatest common divisor of two or more integers. The greatest
common divisor is the largest integer that divides both number1 and number2 without a
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. For example,
GCD(16,28) equals 4 .
The NUMBER arguments are 1 to 29 values. If any value is not an
integer, it is truncated. If any argument is 0, it is ignored. If any
argument is nonnumeric or less than 0, an error value is returned.
You also can use ranges of values in place of single-number values
in this function.
INT The INT function rounds a number down to the nearest integer.
For example: INT(2.6) equals 2 and INT(–2.6) equals –3.