Class LogicalFunction

  • All Implemented Interfaces:
    Function, Function1Arg

    public abstract class LogicalFunction
    extends Fixed1ArgFunction
    Implementation of the various ISxxx Logical Functions, which take a single expression argument, and return True or False.
    • Field Detail

      • ISLOGICAL

        public static final Function ISLOGICAL
      • ISNONTEXT

        public static final Function ISNONTEXT
      • ISNUMBER

        public static final Function ISNUMBER
      • ISTEXT

        public static final Function ISTEXT
      • ISBLANK

        public static final Function ISBLANK
      • ISERROR

        public static final Function ISERROR
      • ISERR

        public static final Function ISERR
        Implementation of Excel ISERR() function.

        Syntax:
        ISERR(value)

        value The value to be tested

        Returns the logical value TRUE if value refers to any error value except '#N/A'; otherwise, it returns FALSE.

      • ISNA

        public static final Function ISNA
        Implementation for Excel ISNA() function.

        Syntax:
        ISNA(value)

        value The value to be tested

        Returns TRUE if the specified value is '#N/A', FALSE otherwise.

      • ISREF

        public static final Function ISREF
    • Constructor Detail

      • LogicalFunction

        public LogicalFunction()