Delta Formula
|
|
Number1
|
Number2
|
Delta
|
|
|
|
|
|
10
|
20
|
0
|
=DELTA(C4,D4)
|
|
|
|
|
50
|
50
|
1
|
=DELTA(C5,D5)
|
|
|
|
|
17.5
|
17.5
|
1
|
=DELTA(C6,D6)
|
|
|
|
|
17.5
|
18
|
1
|
=DELTA(C7,D7)
|
|
|
|
|
17.50%
|
0.175
|
1
|
=DELTA(C8,D8)
|
|
|
|
|
Hello
|
Hello
|
#VALUE!
|
=DELTA(C9,D9)
|
|
|
|
|
|
|
1
|
=DELTA(C10,D10)
|
|
|
|
|
|
|
|
|
|
|
|
What Does It Do ?
|
|
|
|
|
|
|
|
This
function compares two values and tests whether they are exactly the same.
|
||||||
|
If the numbers
are the same the result will be 1, otherwise the result is 0.
|
||||||
|
It only
works with numbers, text values produce a result of #VALUE.
|
||||||
|
The
formatting of the number is not significant, so numbers which appear rounded
due
|
||||||
|
to the
removal of decimal places will still match correctly with non rounded values.
|
||||||
|
|
|
|
|
|
|
|
|
Syntax
|
|
|
|
|
|
|
|
=DELTA(FirstNumber,SecondNumber)
|
|
|
|
|||
|
|
|
|
|
|
|
|
|
Formatting
|
|
|
|
|
|
|
|
No
special formatting is needed.
|
|
|
|
|
||
|
|
|
|
|
|
|
|
|
Example
|
|
|
|
|
|
|
|
The
following table is used to determine how may pairs of similar numbers are in
a list.
|
||||||
|
The =DELTA()
function tests each pair and then the =SUM() function totals them.
|
||||||
|
|
|
|
|
|
|
|
|
|
Number1
|
Number2
|
Delta
|
|
|
|
|
|
10
|
20
|
0
|
=DELTA(C30,D30)
|
|
|
|
|
50
|
50
|
1
|
=DELTA(C31,D31)
|
|
|
|
|
30
|
30
|
1
|
=DELTA(C32,D32)
|
|
|
|
|
17.5
|
18
|
1
|
=DELTA(C33,D33)
|
|
|
|
|
12
|
8
|
0
|
=DELTA(C34,D34)
|
|
|
|
|
100
|
100
|
1
|
=DELTA(C35,D35)
|
|
|
|
|
150
|
125
|
0
|
=DELTA(C36,D36)
|
|
|
|
|
|
Total Pairs
|
4
|
=SUM(E30:E36)
|
|
|