GCD() function

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,…) […]

Read more →

RAND Function

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: […]

Read more →

Roman() Function

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: […]

Read more →

Arabic() Function

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 […]

Read more →

Sum() Function

The Excel SUM function returns the sum of values supplied as multiple arguments. SUM can handle up to 255 individual arguments, which can include numbers, cell references, ranges, arrays, and constants. Syntax The syntax for the SUM function in Microsoft […]

Read more →