formula for fantasy baseball!

hello, this is my first post into this forum, I did some searching and found people using excell to do NCAA bracket scoring and such, but nothing for what I'd like to do. I know a little about excel but I can't figure out what forumla to use for this.

I'm in a fantasy baseball auction league, without a big long rundown on what that entails I'll give the cliff notes version of it. Basically, every team has a CAP of 75 dollars to spend on players. players are then "auctioned" off to each team. bidding in 50 cent increments. I'd like to be able to keep track of all of this in Excel, players teams have already aquired, how much they paid for them, how much cap they have left, and what their MAX bid would be

The problem I'm having is with the MAX bid part. because you need a minimum of 22 players (and can have up to 27 players) it makes things tricky. so if a team is bidding on its first player (still has their full 75 dollars left) their maximum bid would be 64.50 (if they bid 64.50 on 1 player, theyd have just enough money to fill their roster with 21 players at 50 cents each).

I tried to attach a file of the excell sheet, but it won't allow that type of attachment, I attached a jpg pic so you can at least see what I'm talking about. I'd be more than happy to E-mail you the sheet if youd like as well


thanks in advance!
-Nick