IfNa (Keikai Spreadsheet Build 6.0.0 API)

java.lang.Object
- org.apache.poi.ss.formula.atp.IfNa

All Implemented Interfaces:

FreeRefFunction
```
public final class IfNa
extends Object
implements FreeRefFunction
```
Implementation of 'Analysis Toolpak' the Excel function IFNA() Syntax:
IFNA(test_value, default_value)
test_value The value to be tested
default_value The value to be tested

Returns default_value if test_value is '#N/A', test_value otherwise.

- Field Summary
  
  Fields
  Modifier and Type Field Description
  
  static FreeRefFunction instance
- Method Summary
  
  All Methods Instance Methods Concrete Methods
  Modifier and Type Method Description
  
  ValueEval evaluate(ValueEval[] args, OperationEvaluationContext ec)
  - Methods inherited from class java.lang.Object
    clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

- Field Detail
  - instance
```
public static final FreeRefFunction instance
```
- Method Detail
  - evaluate
```
public ValueEval evaluate(ValueEval[] args,
                          OperationEvaluationContext ec)
```
    Specified by:
    
    evaluate in interface FreeRefFunction
    
    Parameters:
    
    args - the pre-evaluated arguments for this function. args is never null, nor are any of its elements.
    
    ec - primarily used to identify the source cell containing the formula being evaluated. may also be used to dynamically create reference evals.
    
    Returns:
    
    never null. Possibly an instance of ErrorEval in the case of a specified Excel error (Exceptions are never thrown to represent Excel errors).