How to use the DELTA function in Excel :Tutorial

preview_player
Показать описание
The DELTA function in Microsoft® Excel is used to test two values for equality. The function returns 1, if the two supplied values are equal and returns 0 if it’s otherwise. Use the DELTA function in Microsoft® Excel by following the steps shown in this video.
Рекомендации по теме
Комментарии
Автор

Nice explanation. A feature in Excel is being able to copy the formula and maps it to the new row values, but probably you're trying to showcase entering the function. It would be nice to explain use cases as well since you can get 3 values out of Delta: match, no match, and NaN.

guslopez
Автор

Good clear video. I have used the DELTA function in Excel for some years but sometimes get a 0 when the numbers clearly match. I am matching a number with the result of an sum function and copy the formula down the column so they formula remains consistent. There are no fractions involved but this month I have two 0's when I can see the numbers show as the same. Once I visually confirm the numbers are the same I ignore the 0's but would be interested to find the reason if you or anyone knows. Thanks

barbaramackenzie