Staff Skills academy+
Home » Courses » Microsoft Excel Intermediate Certification » Module 20 : RANDBETWEEN Function (Insert Random Numbers)
Module 20 : RANDBETWEEN Function (Insert Random Numbers)
20.1 RANDBETWEEN Function The RANDBETWEEN function returns random integer numbers between minimum and maximum limits you specify. A different random number is calculated every time. The formula for the RANBETWEEN function is as follows: =RANDBETWEEN(bottom, top) Bottom refers to the smallest integer, or minimum, you want the function to return. Top refers to the largest integer, or maximum, you want the function to return. For example, if you want the RANDBETWEEN function to r...
Lessons
- Module 1: SumProduct Formula
- Module 2 : Data Validation With Date
- Module 3 : Data Validation with Whole Numbers
- Module 4 : Data Validation with List Feature
- Module 5 : ABS Function
- Module 6 : CHAR Function
- Module 7 : CLEAN Function
- Module 8 : CODE Function
- Module 9 : EXACT Function
- Module 10 : AVERAGEA Function
- Module 11 : AVERAGEIF
- Module 12 : AVERAGEIFS Function
- Module 13 : CELL Function With 10 Variations
- Module 14 : LARGE Function
- Module 15: MAX Function
- Module 16: MEDIAN Function
- Module 17: MIN Function
- Module 18: MODE Function
- Module 19 : N Function
- Module 20 : RANDBETWEEN Function (Insert Random Numbers)
- Module 21 : RANK Function
- Module 22 : Remove Duplicate Values
- Module 23 : ROUND Function Up/Down
- Module 24 : Add Custom Background Image
- Module 25: Change Text To Lower Case
- Module 26: Change Text To Upper Case
- Module 27: Change Text To Proper Case
- Module 28: Insert Special Character
- Module 29: Use Autofill : A Time Saving Trick
- Module 30: Treemap Chart
- Module 31: Sunburst Chart
- Module 32: Use Tables
- Module 33: Use Templates
- Module 34: Use Themes