public final class Delta extends Fixed2ArgFunction implements FreeRefFunction
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.
|Constructor and Description|
|Modifier and Type||Method and Description|
public static final FreeRefFunction instance
public ValueEval evaluate(ValueEval args, OperationEvaluationContext ec)
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.
null. Possibly an instance of
ErrorEvalin the case of a specified Excel error (Exceptions are never thrown to represent Excel errors).
Copyright 2022 The Apache Software Foundation or its licensors, as applicable.