Actually, this is working out pretty well.
Adding the 3 values, plus 6 times the minimum value, plus the maximum value, resulting in a score out of 100.
SCORE = "B13+C13+D13+(MIN(B13:D13)*6)+(MAX(B13:D13)"

These numbers look pretty good to me:

10 10 10 100
9 9 9 90
1 1 1 10

5 5 5 50
6 5 4 45
7 5 3 40
7 4 4 46

9 9 2 41

10 9 1 36
6 4 3 37


OK, 36 might look a bit generous for 10,9,1, but that sort of large disparity in the three figures would be very rare. I'm really happy with this.

Thanks again for all the help.

---------- Post added at 08:17 PM ---------- Previous post was at 08:13 PM ----------

Melvinrobb, I had just written that reply before you posted there.
Thanks again for taking the time to explain your method.

It's certainly more complex, but I'll play with it a bit because it makes a lot of sense.