1.Here 10-50 and 300-400 numbers are taken for example to generate the random numbers within the limit in Excel. We using the command of "randbetween" for generate the random numbers and we won't get the decimal or fraction values.2.Now type "=randbetween(10,50)" which means to generate the random value between the bottom value of 10 and top value of 50 and click enter now we will get 11 as random generated number.3.Do the same thing for 300-400 as "=randbetween(300-400)".You will the 303 will generate as random number. Whenever you press the "F9" button different random numbers will generate with in the given range.4.And also you can copy the same formula in another cell and both won't generate the same numbers with in the range.
Home
Microsoft Office How to Generate random numbers (integers) in Excel

By rawhy
Apr 17, 2010 09:39 PM
The next big software update for iPhone is coming sometime in April and will include a Food section in Apple News+, an easy-to-miss new Ambient Music app, Priority Notifications thanks to Apple Intelligence, and updates to apps like Mail, Photos, Podcasts, and Safari. See what else is coming to your iPhone with the iOS 18.4 update.
Comments
Be the first, drop a comment!