Looking to do a multiple IF function that then computes a number

here is the data set:

92.1% 99.0% 94.0% 84.0% 66.0% 75.0% 89.0% top 3 minus 0; bottom 3 minus 50; all others minus 25 (out of 100 total)
0.0% 2.3% 0.0% 2.5% 0.0% 5.0% 3.0% minus 25 pts if not meeting 2% standard
3.9% 3.5% 0.0% 3.6% 0.0% 1.0% 0.0% minus 25 pts if not meeting 5% standard
3.0% 5.0% 0.0% 1.2% 0.0% 2.0% 0.0% minus 25 pts if not meeting 0% standard
[FORMULA]

So out of the top row, would like to figure out if cell Row1Column1 is in the top 3 highest numbers for the entire row, and if top 3 then minus 0; bottom 3 minus 50; all others minus 25 (starting from 100 possible points), then subtract 25 from that computed value if cell R2C1 if it's less than or equal to 2%; then subtract 25 from the computed value if cell R3C1 is not less than or equal to 5%; then subtract 25 again if cell R4C1 is equal to 0%.

untitled.JPG

Hopefully this will help...

Book1.xlsx

All right, hopefully the file is there. Cant upload from my LAN at work.

So I would like excel to compute in cell B9 "IF" Unit A is in the top 3 highest unit scores for metric 1row, and if top 3 then subtract 0; bottom 3 subtract 50; and if not top or bottom then subtract 25 (starting from 100 possible points). Then subtract 25 from that computed value if cell B5 is less than or equal to 2%; then subtract 25 from the computed value if cell B6 is not less than or equal to 5%; then subtract 25 again if cell B7 is equal to 0%.

This final computed number could be a negative number, but I would like to only show zero in that case.

I would then copy paste the formual into the remaining cells for row 9.
Thanks!