Overview | Package | Class | Use | Tree | Deprecated | Index | Help
PREV CLASS NEXT CLASS | FRAMES NO FRAMES
SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD

## org.apache.poi.ss.formula.functions
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 Summary
`static Function` | `ISBLANK`
`static Function` | `ISERR` Implementation of Excel `ISERR()` function.
`static Function` | `ISERROR`
`static Function` | `ISLOGICAL`
`static Function` | `ISNA` Implementation for Excel ISNA() function.
`static Function` | `ISNONTEXT`
`static Function` | `ISNUMBER`
`static Function` | `ISREF`
`static Function` | `ISTEXT`

Constructor Summary
`LogicalFunction()`

Method Summary
`ValueEval` | `evaluate(int srcRowIndex, int srcColumnIndex, ValueEval arg0)` see `Function.evaluate(ValueEval[], int, int)`
`protected abstract boolean` | `evaluate(ValueEval arg)`

Methods inherited from class org.apache.poi.ss.formula.functions.Fixed1ArgFunction
`evaluate`

Methods inherited from class java.lang.Object
`clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait`

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()

Method Detail

### evaluate

    public ValueEval evaluate(int srcRowIndex,
                              int srcColumnIndex,
                              ValueEval arg0)

  Description copied from interface: `Function1Arg`
  see `Function.evaluate(ValueEval[], int, int)`

### evaluate

    protected abstract boolean evaluate(ValueEval arg)

  Parameters:
    `arg` - any `ValueEval`, potentially `BlankEval` or `ErrorEval`.

Overview | Package | Class | Use | Tree | Deprecated | Index | Help
PREV CLASS NEXT CLASS | FRAMES NO FRAMES
SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD

Copyright 2017 The Apache Software Foundation or its licensors, as applicable.