Class LogicalFunction

java.lang.Object
org.apache.poi.ss.formula.functions.Fixed1ArgFunction
org.apache.poi.ss.formula.functions.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 Details

    • 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 Details

    • LogicalFunction

      public LogicalFunction()
  • Method Details