Use Of Delta
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)
| |||
कोई टिप्पणी नहीं:
एक टिप्पणी भेजें