Golf game: Banker Game

Hi All-

I brought myself to the outer envelop of my abilities with this one and I hope someone can either tell me it can be done as I envision it or it simply cannot.

The game in question is called banker and you can read about it's play here: Every hole is a new game. The minimum bet amount is established before the round by the group. The maximum bet amount for each hole is determined by the player that is the banker. The banker changes hole by hole. The banker is always the person that holed out first with the lowest score on the previous hole. Example:
If two people tie for the low score with birdies, the person who made the longer putt is the banker on the next hole. At the beginning of the round, a minimum bet of $10 per hole is established. For example, the banker declares the maximum bet $100. Each player in the group plays a 1-on-1 game against the banker only. Before teeing off, each player declares the amount of their match with the banker, between $10-100. Remember each player plays an individual match against the banker. Example:
If player A is the banker in a foursome, the matches are as follows:
Player A vs. B, for amount determined by Player B.
Player A vs. C, for amount determined by Player C.
Player A vs. D, for amount determined by Player D.


Essentially there are 4 players.

If Player A is BANKER, he would have a bet with Player B, a bet with Player C and a bet with Player D. All separate. I cannot quite figure out how to write a formula to parse the net scores entered, compare each to Player A net score and then change the entered bet to either, for example, $10.00 for a win, -$10.00 for a loss or $0.00 for a push.

Is this doable in a single formula or would it take some cell gymnastics I am unaware of to make it happen?

Thanks for anyone who might have some thoughts!

Cheers,
C