The following is a formula i am using,
=IF(D9="","",RANK(D9,$D$9:$F$9))
this Ranking formula is working for me fine but what i am trying to do is if is possible to have an if, and, formula then rank.
so in words it would only Rank IF =(D$3+D$4+D$5)>=$B$4 AND =(D$6+D$7)>$B$7 AND =D$8>=$B$8 otherwise FAIL and then to copy this over the other ranking cells to also incorporate the IF(D9="","") part as i will have empty cells within the rank selection.
I have attached also my book for reference.