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

Administrative Note:

Welcome to the forum.

We would very much like to help you with your query, however the thread title does not really convey what your request is about. Tell us what you are trying to do, not how you think it should be done.

Please take a moment to amend your thread title. Make sure that the title properly explains your request. Your title should be explicit and not be generic (this includes function names used without an indication of what you are trying to achieve).

Please see Forum Rule #1 about proper thread titles and adjust accordingly. To edit the thread title, open the original post to edit and then click on Go Advanced (bottom right) to access the area where you can edit your title.

(Note: this change is not optional. As you are new, I've changed it for you.)