Class Delta
java.lang.Object
org.apache.poi.ss.formula.functions.Fixed2ArgFunction
org.apache.poi.ss.formula.functions.Delta
- All Implemented Interfaces:
FreeRefFunction
,Function
,Function2Arg
Implementation for Excel DELTA() function.
Syntax:
DELTA (number1,number2 )
Tests whether two values are equal. Returns 1 if number1 = number2; returns 0 otherwise. Use this function to filter a set of values. For example, by summing several DELTA functions you calculate the count of equal pairs. This function is also known as the Kronecker Delta function.
- If number1 is nonnumeric, DELTA returns the #VALUE! error value.
- If number2 is nonnumeric, DELTA returns the #VALUE! error value.
- Author:
- cedric dot walter @ gmail dot com
-
Field Summary
Fields -
Constructor Summary
Constructors -
Method Summary
Methods inherited from class org.apache.poi.ss.formula.functions.Fixed2ArgFunction
evaluate
-
Field Details
-
instance
-
-
Constructor Details
-
Delta
public Delta()
-
-
Method Details
-
evaluate
Description copied from interface:Function2Arg
- Specified by:
evaluate
in interfaceFunction2Arg
-
evaluate
- Specified by:
evaluate
in interfaceFreeRefFunction
- Parameters:
args
- the pre-evaluated arguments for this function. args is nevernull
, 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).
-