Forum Discussion
Average the closets two out of three number
I have the three numbers in a single row (column B, C, &D). I need a formula that will pick the two numbers out of those three and average them. Example: The formula looks ate column B row 1, colu...
In E1:
=IF(ABS(B1-C1)<=MIN(ABS(C1-D1),ABS(D1-B1)),AVERAGE(B1,C1),IF(ABS(C1-D1)<=MIN(ABS(D1-B1),ABS(B1-C1)),AVERAGE(C1,D1),AVERAGE(D1,B1)))
Fill down.