Random Function Excel - Ballot - Microsoft Community Hi, I'm using the following formula "=Rand()*(b-a)+a" for a ballot. I have 20 numbers, reach refers to a name for a lucky individual who is entitled for a prize.
