The Excel EVEN function returns the next even integer after rounding a given number up. The EVEN function always rounds numbers up (away from zero) so positive numbers become larger and negative numbers become smaller (i.e. more negative). Syntax The […]

The Excel ODD function returns the next odd integer after rounding a given number up. The ODD function always rounds numbers up (away from zero) so positive numbers become larger and negative numbers become smaller (i.e. more negative). Syntax The […]

The Excel LCM function returns the least common multiple of integers. The least common multiple is the smallest positive integer that is a multiple of all supplied numbers. Syntax The Syntax for the LCM Formula is: =LCM(number1,number2) Function Arguments number1 […]

The Excel GCD function returns the greatest common divisor of two or more integers. The greatest common divisor is the largest integer that goes into all supplied numbers without a remainder. Syntax The Syntax for the GCD Formula is: =GCD(number1,number2,…) […]

The Excel RAND function returns a random number between 0 and 1. RAND recalculates when a worksheet is opened or changed. Purpose: Get a random number between 0 and 1. Return Value: Any decimal number between 0 and 1. Syntax: […]

The Excel ROMAN function converts an Arabic number to Roman. I.e. for a supplied integer, the function returns a text string depicting the roman numeral form of the number. Syntax The syntax for the ROMAN function in Microsoft Excel is: […]

The Excel Arabic function converts a Roman numeral into an Arabic numeral. Syntax The syntax for the Arabic function in Microsoft Excel is: =ARABIC( text ) Parameters or Arguments text Required. A string enclosed in quotation marks, an empty string […]