Spread Formula Reference
Formula Functions / Functions D to G / 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

    Version Available

    This function is available in product version 1.0 or later.

    See Also

    CONCATENATE | Text Functions