All Implemented Interfaces:
FreeRefFunction, Function, Function2Arg

public final class Delta extends Fixed2ArgFunction implements FreeRefFunction
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 Details

  • Constructor Details

    • Delta

      public Delta()
  • Method Details