Detailed requirements are spelled out in the attached workbook.
Basically, players of differing skills, using two different tees, each with its own allocated handicap, adjust their gross scores to net IF their personal handicap number >= to the number allocated (a) to that hole (b) from the tee used by that player. I can do it using several helper columns, but I expect that a more skilled Excel-person can conjure up a more elegant solution...I hope so.
Bookmarks