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
!
Bookmarks