Difference between revisions of "Manuals/calci/DELTA"

From ZCubes Wiki
Jump to navigation Jump to search
(Created page with "<div id="6SpaceContent" class="zcontent" align="left"> <font color="#000000"><font face="Arial, sans-serif"><font size="2">'''DELTA'''</font></font><font face="Arial, sans-se...")
 
Line 1: Line 1:
<div id="6SpaceContent" class="zcontent" align="left"> <font color="#000000"><font face="Arial, sans-serif"><font size="2">'''DELTA'''</font></font><font face="Arial, sans-serif"><font size="2">(N1,N2)</font></font></font>
+
=DELTA(n1,n2)=
  
<font color="#000000"><font face="Arial, sans-serif"><font size="2">Where 'N1' s the first number and 'N2' is the second number. </font></font></font>
+
*Where 'n1' is the first number and 'n2' is the second number.
  
</div>
+
DELTA() compares the two numbers to find if they are equal. Displays '1' if n1 and n2 are equal, else displays '0'.
----
 
<div id="7SpaceContent" class="zcontent" align="left"> 
 
  
* <font color="#000000"><font face="Arial, sans-serif"><font size="2">DELTA shows the error value, When 'N1' and 'N2' are nonnumeric. </font></font></font>
+
==Description==
 +
DELTA(n1,n2)
  
</div>
+
For Example,
----
+
DElTA(5,5) ''returns 1''
<div id="12SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="left">
 
  
DELTA
+
*Calci returns '1' if n1=n2 and returns '0' if n1<>n2.
  
</div></div>
+
*Calci displays an #ERROR message if numbers are non-numeric.
----
 
<div id="8SpaceContent" class="zcontent" align="left"> 
 
  
<font color="#000000"><font face="Arial, sans-serif"><font size="2">Lets see an example,</font></font></font>
+
*'n2' is optional. If not mentioned, Calci considers it as '0'.
  
<font color="#000000"><font face="Arial, sans-serif"><font size="2">'''DELTA'''</font></font><font face="Arial, sans-serif"><font size="2">(N1,N2)</font></font></font>
+
*This function is also called as Kronecker Delta Function.
  
<font color="#000000"><font face="Arial, sans-serif"><font size="2"><nowiki>=DELTA(4, 3) is 0</nowiki></font></font></font>
+
== Examples ==
  
<font color="#000000"><font face="Arial, sans-serif"><font size="2"><nowiki>=DELTA(3, 3) is 1</nowiki></font></font></font>
 
 
</div>
 
----
 
<div id="10SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="justify">Syntax </div><div class="ZEditBox"><center></center></div></div>
 
----
 
<div id="4SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="justify">Remarks </div></div>
 
----
 
<div id="3SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="justify">Examples </div></div>
 
----
 
<div id="11SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="justify">Description </div></div>
 
----
 
<div id="5SpaceContent" class="zcontent" align="left">
 
 
<font color="#000000"><font face="Arial, sans-serif"><font size="2">  </font></font></font>
 
 
<font color="#000000"><font face="Arial, sans-serif"><font size="2">This function is to calculate whether the two values are equal. It shows 1 if both are equal and 0 for otherwise. </font></font></font>
 
 
</div>
 
----
 
 
<div id="1SpaceContent" class="zcontent" align="left">
 
<div id="1SpaceContent" class="zcontent" align="left">
  
 
{| id="TABLE1" class="SpreadSheet blue"
 
{| id="TABLE1" class="SpreadSheet blue"
 
|- class="even"
 
|- class="even"
| class="  " |
+
| class="  " | '''Function'''
<div id="1Space_Copy" title="Click and Drag over to AutoFill other cells."></div>
+
| class="  " | '''Output'''
| Column1
+
 
| class="  " | Column2
 
| class="  " | Column3
 
| class="  " | Column4
 
 
|- class="odd"
 
|- class="odd"
| class=" " | Row1
+
| class="sshl_f" |DELTA(76,54)
| class="sshl_f" | 0
+
| class="sshl_f" |0
| class="sshl_f" | 1
+
 
| class="sshl_f" |
 
| class="sshl_f" |
 
 
|- class="even"
 
|- class="even"
| class="  " | Row2
+
| class="sshl_f" |DELTA(1000,1000)
| class="sshl_f" |
+
| class="sshl_f" |1
| class="sshl_f SelectTD SelectTD" |
+
 
<div id="1Space_Handle" title="Click and Drag to resize CALCI Column/Row/Cell. It is EZ!"></div><div id="1Space_Copy" title="Click and Drag over to AutoFill other cells."></div>
 
| class="sshl_f" |
 
| class="sshl_f" |
 
 
|- class="odd"
 
|- class="odd"
| Row3
+
| class="sshl_f" |DELTA(0.005,5)
| class="sshl_f" |
+
| class="sshl_f" |0
| class="sshl_f" |
+
 
| class="sshl_f" |
 
| class="sshl_f" |
 
 
|- class="even"
 
|- class="even"
| Row4
+
| class="sshl_f" |DELTA(-200,-200)
| class="sshl_f" |
+
| class="sshl_f" |1
| class="sshl_f" |
+
 
| class="sshl_f" |
 
| class="sshl_f" |
 
 
|- class="odd"
 
|- class="odd"
| class=" " | Row5
+
| class="sshl_f" |DELTA(30)
| class="sshl_f" |
+
| class="sshl_f" |0
| class="sshl_f" |
+
 
| class="sshl_f" |
 
| class="sshl_f" |
 
 
|- class="even"
 
|- class="even"
| Row6
+
| class="sshl_f" |DELTA(0)
| class="sshl_f" |
+
| class="sshl_f" |1
| class="sshl_f" |
 
| class="sshl_f" |
 
| class="sshl_f" |
 
 
|}
 
|}
 
<div align="left">[[Image:calci1.gif]]</div></div>
 
----
 

Revision as of 16:15, 18 November 2013

DELTA(n1,n2)

  • Where 'n1' is the first number and 'n2' is the second number.

DELTA() compares the two numbers to find if they are equal. Displays '1' if n1 and n2 are equal, else displays '0'.

Description

DELTA(n1,n2)

For Example, DElTA(5,5) returns 1

  • Calci returns '1' if n1=n2 and returns '0' if n1<>n2.
  • Calci displays an #ERROR message if numbers are non-numeric.
  • 'n2' is optional. If not mentioned, Calci considers it as '0'.
  • This function is also called as Kronecker Delta Function.

Examples

Function Output
DELTA(76,54) 0
DELTA(1000,1000) 1
DELTA(0.005,5) 0
DELTA(-200,-200) 1
DELTA(30) 0
DELTA(0) 1