I'm working on a character sheet in Excel 2007 and trying to have it automated, so its easy to use. Part of the rules to the game states that by leveling up you get one more skill point which may be applied to health. The health level boost Formula is this: Hp boost= Random # (2-12) +3. per level My set up is like this: lvl 1 Rand#+3 2 Rand#+3 3 Rand#+3 # :sum I have the skill applicator working perfectly, but I have no clue how to get the random numbers stable after the initial load. I can't turn off Auto calculations because I have other elements in the sheet that require it. Thanks!
