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).
Search JabSto ::

Custom Search