Hi,

I have a row of values, where any number below a certain threshold would be displayed as the value preceded by the word "Stop"

e.g. For a threshold of -7.00%:

2.89%, 1.58%, 10.99%, -4.09%, -6.84%, Stop -7.81%, -2.28%

I need to calculate the minimum value (i.e. -7.81%) and have tried to combine the min and right functions, but to no avail.

Is there a way to achieve this?

Thanks in advance.