Thread: Calculating the Absolute Difference between Each List Value and the Minimum Value in the List

Problem:

For each value in List1 (column A), we want to calculate the absolute difference between it and the minimum value in the list.

Solution:

Use the ABS and MIN functions in the following formula:
=ABS(MIN($A$2:$A$8)-A2)