Microsoft Office Tutorials and References

In Depth Information

**Easy Random Number Generation**

The GCD function takes up to 255 values as its arguments. Noninteger values

are truncated. By its nature any returned greatest common divisor must

equal or be smaller than the lowest argument value. Often there is no

greatest common divisor other than 1 — which all integers share. The syntax for

the GCD function follows:

GCD(number1,number2, ...)

The least common multiple is an integer that is the lowest multiple common

among a group of integers. For example, the least common multiple of 2, 4,

and 6 is 12. The least common multiple of 9, 15, and 48 is 720.

The LCM function takes up to 255 values as its arguments. Noninteger values

are truncated. The syntax for the LCM multiple function follows:

LCM(number1,number2, ...)

Easy Random Number Generation

The Excel RAND function returns a number between 0 and 1. And that’s it.

Usually you have to massage the returned number into something useful.

The typical thing to do is multiply it by some number to get it within a range

of values, then add the lower limit to that, and finally to use INT to turn the

whole thing into an integer. The days of drudgery are over!

The RANDBETWEEN function returns a random integer between two values.

Two arguments are used — the low end of the range and the high end of the

range. Just what we need! For example, =RANDBETWEEN(5, 10) returns a

whole number between 5 and 10. Always.

Converting to Roman Numerals

C, V, L, I; I get these mixed up. Is C for 100 or 1000? What is L for? Whew, I

don’t have to memorize these anymore.

The ROMAN function takes care of it all. Just throw a number in the normal

format we are familiar with and out comes the equivalent Roman numeral.

Easy! The syntax is =ROMAN(number to convert, optional style).