AnsweredAssumed Answered

Finding the second best price ?

Question asked by Macl007 on Feb 15, 2010
Latest reply on Feb 19, 2010 by Macl007

Title

Finding the second best price ?

Post

Hey,

I'm trying to write a formula that will give me the second best price out of a series of prices. I explain myself.

Let's say that I have 4 fields, Price1, Price2, Price3 and Price4. I would like to a have a 5th field that would give me the second best price out of the 4 prices. 

 

Can anybody help me because I cannot see how to do that ?

 

Many thanks

 

Outcomes