MIN with different values

Hi,

My issue is that I have a Data set where most of the values are constant the total of these is 100´, but one value will either be included or not depending on the day, lets call this X. I have used =MIN(A:A;5) to retrive the fith smallest value, but this only works on the days X is not included. Would it be possible to use an IF statement? My idea (in theory) is "if the total of all values equals 100´, look for fith smallest. If the total of all values is more that 100´, look for sixth smalles". Is there a way to formulate this?

Thank you in advance, and sorry for a quite confused explanation of the issue.

// Your Excel Rookie.

Try

=IF (SUM(A:A)=100,MIN(A:A,5),MIN(A:A,6))

Assumes total cannot be less than 100

Thank you for your help!