Fantasy Football standings

I'm trying to include Standings on my fantasy football spreadsheet.

I need to Rank first by winning percentage and then by Points Scored as a tie breaker. For example, two teams are 7-5, and "tied" for third place but one team has scored 1050 points while the other has scored 1000. I want the team that scored 1050 to have a Rank of 3 and the team that scored 1000 to have a Rank of 4 instead of both of them having a rank of 3 out of 10.

I have the winning percentages and Points Scored in very different places on my spreadsheet.

I've tried many different things and scoured these forums for a similar problem but can't figure it out. There has to be a way to do this.

I would attach my spreadsheet but it's an invalid file type.

Thanks for any help!

Dude, that works awesome! I put all the fields I needed farther down the spreadsheet where they shouldn't bother anything and copied your formulas exactly. Works like a charm!

Thanks again!