Learn and use RANDBETWEEN function FeedBack You are running a Holiday Raffle, There are 50 guests, each guest was given a number from 1 to 50. Please choose a winner using RANDBETWEEN() Function. Input your Formula in C13 Winning Number Number Correct 0 Percentage 0% Put in formula here Enter Formula in C13 The result of RandBetween is dynamic so it will change with any change to the sheet. So once you have the winning number, type/input it in C5 (don't just copy & paste). If doing this for real, you could Hide cell C13.) Notice once you type into C5, the result in C13 changes