Maybe this is exactly what the CHOOSE-formula is not about, but it would nevertheless be nice if somebody knows a possible expansion/combination to it.

I have bent the CHOOSE-formula's "None of the Conditions","One Condition", "Two Cond." etc, - into somthing like this one:
=CHOOSE((D140<D139)+(D139<D138)+(D138<D137)+1;F140;H140;I140;J140)
which roughly serves its purpose, and with the F140 substituting the"None of the Conditions" bit.

I'd like to specify the conditions further, in order for it to return a differentiated set of calculations.
The mentioned F140 takes care of half the job, but only when none of the other conditions are met. The FColumn actually has its own CHOOSE-formula minding its own business - but is only returned under the given circumstances.

What I would like it to do, is to discard all of the conditions - even if they're all (or particularly) present - if a last condition is met and given priority.
Say all these ((D140<D139)+(D139<D138)+(D138<D137) are in place, but for example the difference between D140 and D137 is not larger than 3* the difference between D138 and D137. Then it should return the F140 or some other cell of choice.
How does one give one of the conditions such a priority?
Having posed this question, I realise it might as well concern some of the IF- or IF(AND)-formulae as well, and yes, any suggestions will be appreciated.
And by the way, I'm curious about the "+1" part and it's function.
Any ideas?'
Thanks in advance
BCB