Which function is used to calculate the absolute difference between two cells in Excel?

To calculate the absolute difference between two cells in Excel, the function used is ABS. This function returns the absolute value of a number, effectively eliminating any negative signs. The formula to find the absolute difference between two cells, say A1 and B1, would typically be written as:

=ABS(A1 - B1)

This operation subtracts the value in cell B1 from the value in cell A1, and then the ABS function converts the result to its absolute value.

Other functions like DIFF do not exist in Excel, and therefore cannot be used to find the absolute difference. The SUM function is used for adding numbers together and does not provide the absolute difference calculation. Similarly, RANGE is not a function used for calculating differences; it usually refers to the difference between the maximum and minimum values in a dataset, or it is used to define a collection of cells, not for calculating absolute differences.