Hi folks

I'm thinking this one will be much simpler than I've made it for myself so I thought I'd see if there was an easier way.

This is a calculation to see if I have won or lost on a horse race using the horses I select & their finish positions. There are five horses, they are arranged from best to worse (Cells A3:A7, with A3 being the top choice) and because of this I may choose to only bet using 3 of the selections (Better odds & less money spent, NB the bets are exotic trifectas so I have to pick the winner, second & third to win the bet) but I might also choose to bet with 4 or all 5 selections.

So,

Cells A3:A7 are my selections results (IE if my horse which was selected as the best choice in cell A3 came 3rd then cell A3 = 3 and so on)

Cell A1 contains the number of selections I made on the bet. So if I only choose the top 3 selections then cell A1=3 etc

Now, what I want to be returned in cell A2 is if I won or lost, IE "Win" or "Loss".

Here is a potential outcome to show you an idea of what might happen.

my 5 selections finished the race in the following fashion;
Selection 1 = 2nd
Selection 2 = 9th
Selection 3 = 1st
Selection 4 = 3rd
Selection 5 = 4th

So if I had bet using all 5 selections I would have won, because I used 5 selections & picked 1st, 2nd & 3rd places. But if I only bet using the top 3 selections I would have lost because I only picked 1st & 2nd and my other selection ran 9th.

Footnote: The races may have many more horses, the 5 selections are based on my knowledge of horses & racing etc (IE I don't win much LOL)

There are alot of other calculations within my racing formulas & selections but this one would be a simple way of seeing the results when analysis historic races and the selections I may have made in past races.

Any help is much appreciated.

Cheers

Mik