AnsweredAssumed Answered

Not MAX, Not MIN, Not AVG - 'Middle' of 3 values

Question asked by etripoli on Aug 28, 2009
Latest reply on Aug 31, 2009 by etripoli

Title

Not MAX, Not MIN, Not AVG - 'Middle' of 3 values

Post

Google search turned up fruitless.  If I have 3 values, Height, Width, and Depth, what's the simplest calculation available to find out which dimension is the middle value?  I'm currently using:

 

Sum ( height; width; depth ) - Min ( height; width; depth) - Max ( height; width; depth )

 

But I suspect there is a better way.  Kudos will be given to the best solution!

Outcomes