I’m not even sure how to ask this, but it’s a question for someone who understands Google sheets formulas and maths!

I’m looking for a formula that will look at the values contained in three cells, and return the difference between the two values furthest apart. An added complication possibly is that some of the values will be minus figures. So for example:

1, 4, -6 = 10 //

2, 5, 8 = 6 //

-3, -9, 5 = 14 //

The figures will be more complex than the above but hopefully it gives you an idea. I wonder whether this can be done, and if so, does anyone know how?

Thank you for any help.

beforeposting your question.