How to rank while comparing 2 cells

Closed
yusriza Posts 2 Registration date Tuesday March 17, 2015 Status Member Last seen March 18, 2015 - Mar 17, 2015 at 11:31 PM
I need favor...

what should i do to set a rank while comparing values of 2 cells.

Cell1 (XM Grade)

Cell2 (Pass/Fail)

Rank ( excellent grade/point and pass get 1st rank)

example Point 1.4, PASS rank 1
1.5, FAIL rank 4
1.6, PASS rank 2
4.4, PASS rank 3