Spread Formula Reference
Formula Functions / Functions D to G / FORMULATEXT
In This Topic
    FORMULATEXT
    In This Topic

    This function returns a formula as a string.

    Syntax

    FORMULATEXT(reference)

    Arguments

    Specify the reference to single cell or range of cells for the argument.

    Remarks

    In this function, text displayed in the formula bar of the specified cell is returned. Reference argument can refer to cell (or cells) of another worksheet or workbook too. Value of upper leftmost cell or row is returned, if an entire row or column is refered.

    Data Types

    Accepts cell reference for argument. Returns string data.

    Examples

    FORMULATEXT(B7) gives the value #N/A

    Version Available

    This function is available in Spread for Windows Forms 11.0 or later.