RELDIFF(…num-expr…, …num-expr…)
num1, num2 -> FLOAT
Compare the two operands A and B by computing:
MIN(ABS(A-B), MAX(A, B)) / MAX(ABS(A-B), MAX(A, B))
Returns 0 when A = B.
| expression | evaluates to |
|---|---|
| RELDIFF(1, 1) | 0 |
| RELDIFF(10, 9) | 0.1 |
| RELDIFF(9, 10) | 0.1 |
| RELDIFF(-9, -10) | 0.1 |
| RELDIFF(1, -10) | 1.1 |