Function isFormulaText

  • True for a formula input: text starting with = (more than =). '=… is text.

    Parameters

    • input: unknown

      a cell input

    Returns input is string

    true for a formula text

    Example

    isFormulaText("=B2*C2");   // true
    isFormulaText("'=1+1"); // false – text "=1+1"

    Since

    1.1.99