Formula Help

[Mark_Smith1985]

I'm looking for help with these to spread sheets.  In the first picture I'm wanting the two tables to know when a team has won the division by the number 1 changing to a C for champions and if teams are in the relegation zone in the first division and can't finish third bottom then number changes to an R and if the second place team can't be caught from third place but can't win the league the number 2 changes to a P for promoted.

In the second picture I'm wanting the rankings table to tell me when A player can't not finish lower than 8th position meaning that that player has qualified for the end of season Masters competition.

If anyone can help me I would be most grateful.

[#2]

@Mark_Smith1985 

Hi Mark,

I hope you have managed to sort out all your League table issues!

if you are happy with the support I have given you , I'd be grateful if you could mark this as complete/best solution.

many thanks

Peter

[#3]

Hi Peter

Yes you have helped me massively solve the issues I have had.

What do i need to do then to close the job as completed?

Kind regards

Mark

[#4 · Accepted solution]

@Mark_Smith1985 

Hi Mark,

There should be a blue box "Mark as best response" at the bottom - just press on that.

thanks!

Peter