Hi

I'm having an issue getting a formula working. I believe it needs nested if statements to do it but I've not been able to after multiple attempts. I've added a full description of what is needed in the attached spread sheet.

Any help greatly greatly appreciated

Excel table.xlsx
!