DELTA Function (Functions in Excel)
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) |
0 comments:
Post a Comment