1 2 Previous Next 23 Replies Latest reply on Aug 31, 2009 9:52 AM by etripoli

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

    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!

        1 2 Previous Next