Microsoft Office Tutorials and References

In Depth Information

**GCD**

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.

NUMBER

The multiple to which to round the value to.

SIGNIFICANCE

Figure 10.15

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

remainder.

=GCD(number1,number2, ...)

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.

NUMBER

INT
The
INT
function rounds a number down to the nearest integer.

=INT(number)

For example:
INT(2.6)
equals 2 and
INT(–2.6)
equals –3.