Description:
???? Learn advanced excel with our complete excel training course: https://eduolio.com/excel-course/
RAND & RANDBERTWEEN formula in excel helps us generate random numbers. Here's how to generate random numbers in excel:
1. Type =RAND() and done, excel will generate random number in excel
2. If you don't want integers then type =RAND()*100 and remove all extra decimal places
3. Once you generate random numbers, make sure to copy and paste them as values in another column as whenever the sheet updates the formula also gets updated
4. Type =RANDBETWEEN(Start Value, End Value) to generate random numbers in excel within a range.
Voila, know you have build a random number generator in excel.
If you want to learn more excel concepts like pivot tables, dashboards, vlookup, IF formulas, conditional formatting, macros etc. Then checkout our advanced Excel course with over 10+ hours of content, 50+ exercises, doubt support and much more.
Excel Pro+ Course ► https://eduolio.com/excel-course/
????Follow us on:
Instagram: https://www.instagram.com/eduolio/
Website: https://eduolio.com
#excel #exceltips #exceltutorial #microsoftexcel #tutorial #microsoftoffice #googlesheets
Share this link via
Or copy link























