Looking for some assistance - I've had a need to use anything other than very basic formulas in Excel, but I'm now struggling to generate the information that I want.
In the attachment formula, I have some ratings, and have calculated, in column entitled Diff, the difference between the highest rating, an each of the others. Now I'm looking to automatically add the decimal odds from the doc entitled appendix_6...
Therefore, a score of 0 in column named Diff would result in a total of 1.00 being placed in the Decimal Odds column of the same sheet, and:
Diff = 1, therefore Decimal Odd = 0.9
Diff = 2, therefore Decimal Odd = 0.8
Which formula would assist me in producing this data easily?
Any assistance greatly appreciated.