I am looking for some assistance on how to put together a function that will provide for me 1 of 3 results, (0, 1 or 2).
Example Attached
What I would like to do is have a function to have the results for the "Pts" (D) Column be either 0, 1 or 2 based on the following.
PM (D)<1.84 (F:10) = 2
PM (D)<2.25 (E:10), >1.84 (F:10) = 1
PM (D)>2.25 (E:10) = 0
Sounds confusing. Any help is much appreciated