Excel help RNG and IF statement

[luigi]

hey guys, this is probably a very basic thing to do in excel.. i have very little experience with IF statements so please bear with me

Lets say that i have a variation of minutes i'd expect a player to play, i understand that i could use the RANDBETWEEN function to get a variation in minutes played..

the problem i have is that I want the total minutes played for the entire team to equal a fixed number (say 240 minutes)... how would I go about this

thanks very much for any input/help

luigi

[suicidekings]

If you know how many minutes you expect from each player, then it's as simple as summing them up and normalizing them. That would just be taking 240/your total and then multiplying each players minutes by the result. That's probably the easiest way, assuming that the % each player plays of available minutes is relatively consistent from game to game.