Microsoft Office Development and Consultancy
 Home|

Excel

|VBA|C#|Finance|Tools|Newsletter|Feedback|Contact 
 Excel > Functions > Engineering > DELTA

 

DELTA(number1, number2)

 
 Returns the numerical value indicating if two numbers are equal.

 number1The first number.
 number2The second number.

 REMARKS
 
  • In Excel 2007 (and later) this function has been removed from the Analysis ToolPak add-in and is available as standard.
     
  • In Excel 2003 this function is only available when you have the Analysis ToolPak add-in loaded.
     
  • If any of the arguments are not numeric, then #VALUE! is returned.
     
  • If "number1" = "number2", then 1 is returned.
     
  • If "number1" <> "number2", then 0 is returned.
     
  • If "number2" is left blank, then 0 is used.
     
  • This function is often used to help filter out values.
     
  • This function is also known as the Kronecker Delta function.

     EXAMPLES
     
     A
    1=DELTA(5,4) = 0
    2=DELTA(5,5) = 1
    3=DELTA(12.3,12.3) = 1
    4=DELTA(0,0) = 1
    5=DELTA(0) = 1
    6=DELTA(1) = 0
    7=DELTA("some text",5) = #VALUE!
    8=DELTA(5,"some text") = #VALUE!
     

     Functions - D | Index - D | Office Online 2013 | 2010 | 2007 | 2003 

     © 2013 Better Solutions Limited. All Rights Reserved.Top | 03-Jan-2013