Information Functions

Error / Numerical / General Information Functions.
  • IFEMPTY

    Returns the first value if this value is not empty, otherwise returns the second value

    IFEMPTY("","some text")
    Try this example
    value1 (any)
    First value
    value2 (any)
    Second value
  • IFERROR

    Receives two values (or expressions) and tests if the first of these evaluates to an error.

    IFERROR({var1},"Some text")
    Try this example
    value (mixed)
    The value, reference, or formula to check for an error.
    value_if_error (string)
    The value to return if an error is found.
  • ISBLANK

    Checks whether the referenced variable is empty.

    ISBLANK({var1})
    Try this example
    value (any)
    Reference to the variable that will be checked for emptiness.
  • ISEMAIL

    Validates value as Email

    string (string)
    String to check
  • ISERR

    Checks whether a value is an error other than `#N/A`.

    ISERR({var1})
    Try this example
    value (string)
    The value to be verified as an error type other than #N/A.
  • ISERROR

    Checks whether a value is an error.

    ISERROR({var1})
    Try this example
    value (string)
    The value to be verified as an error type.
  • ISEVEN

    Checks whether the provided value is even.

    value (number)
    The value to be verified as even.
  • ISLOGICAL

    Checks whether a value is `TRUE` or `FALSE`.

    ISLOGICAL({var1})
    Try this example
    value (boolean)
    The value to be verified as a logical TRUE or FALSE.
  • ISNA

    Checks whether a value is the error `#N/A`.

    ISNA({var1})
    Try this example
    value (string)
    The value to be compared with the error value #N/A.
  • ISNONTEXT

    Checks whether a value is non-textual.

    ISNONTEXT(123)
    Try this example
    value (any)
    The text to be checked.
  • ISNUMBER

    Checks whether a value is a number.

    ISNUMBER(4)
    Try this example
    value (any)
    The value to be verified as a number.
  • ISODD

    Checks whether the provided value is odd.

    value (number)
    The value to be verified as odd.
  • ISTEXT

    Checks whether a value is text.

    ISTEXT("cat")
    Try this example
    value (any)
    The value to be verified as text.
  • ISURL

    Validates value as URL

    ISURL("https://example.com")
    Try this example
    string (string)
    String to check
  • N

    Returns the argument provided as a number.

    value (any)
    The argument to be converted to a number.
  • NA

    Returns the "value not available" error, `#N/A`.

  • TYPE

    Returns a number associated with the type of data passed into the function.

    value (mixed)
    The data whose type is to be determined.