Spread WPF 17
Spread WPF Documentation / Formula Reference / Formula Functions / GCD
In This Topic
    GCD
    In This Topic

    Summary

    This function returns the greatest common divisor of two numbers.

    Syntax

    GCD(number1,number2)

    Arguments

    The arguments are two numeric values. If the arguments are not integers, they are truncated to integers. This function can have up to 255 arguments.

    Remarks

    The greatest common divisor is the largest integer that divides both numbers without a remainder.

    Data Types

    Accepts numeric data for all arguments. Returns numeric data.

    Examples

    GCD(B5,G7)

    GCD(R5C2,R7C7)

    GCD(3348,972) gives the result 108 GCD(12.8,16.3) gives the result 4

    See Also