Such is the nature of randomness.
The OP wanted a simple way to generate some random scenarios and realized the split might not be exact.
Excel - randomizing data for splitting farmland
