SpreadJS 13
SpreadJS Documentation / Formula Reference / Formula Functions / EXACT
In This Topic
    EXACT
    In This Topic

    This function returns true if two strings are the same; otherwise, false.

    Syntax

    EXACT(text1,text2)

    Arguments

    The arguments are text strings.

    Remarks

    This function compares the string in the first argument to the string in the second argument.

    Although this function is case-sensitive, it ignores formatting differences.

    Data Types

    Accepts string data for both arguments. Returns boolean data (true or false).

    Examples

    EXACT(A3,A5)

    EXACT(R3C1,R5C1)

    EXACT(""SPREAD"",""spread"") gives the result FALSE

    See Also