Calculate difference between values from three columns

[Ruchita]

Hi,

I need to calculate the difference amongst values present in three columns.

It needs to look something like this:

A	B	C	Difference
10	10	10	0
10	10	9	1
10	0	0	10
10	9	10	1

Can someone guide me to formula or function that can help me acheive this result ?

[RADSr]

Values 1, 9, 8   What result do you expect?   

You've mentioned that ties are ignored, but what exactly is the algorithm you are trying to employ?   

[Prince · Accepted solution]

If I understood the case correctly, you need the following:

max(abs(A-B), abs(B-C), abs(A-C))

the maximum of the absolute difference between any 2 columns, right?

[Ruchita]

Hi Prince,

Thank you for your understanding of the case aptly. 

I used a nested max() because individual max() gives an error that it accepts only 2 parameters, something like this:

max( abs(A-B),

            max(

                        abs(B-C), abs(A-C)

                 )

)

Appreciate your prompt response and support !