Is it possible to create random teams that also fit under a salary cap on excel? I would like to make random basketball teams that fit under a salary cap of $60,000. If I have 10 centers, power forwards, small forwards, shooting guards and point guards with assigned values can I randomly generate a starting lineups of 1 C and 2 of every other position? Thanks to anyone who can help.