00:00If you need to generate test data or populate the spreadsheet with sample
00:03values for testing purpose, using ran between function and or ran function can
00:09help you quickly generate random number within a desired range. Let me show you
00:13how this is done. Let's say for example if you need to generate anywhere number
00:17between 1 to 1000 on say this area here, you highlight the area then you say
00:23equal ran between and the first argument will be the minimum range for the value
00:29which is going to be 1 and the second argument in ran between will be 1000
00:33which is the maximum value. Now hold ctrl and press enter this will generate
00:38numbers between 1 to 1000 on the selected range here but what if you want to
00:44display let's say for example currency a dollar value to do that you're gonna
00:49have to use a equal ran this will generate any numbers between 0 to 1 and
00:55basically you're gonna multiply that by 1000 because that's our maximum value
01:00that we are stipulating here and then you're gonna take this ran function
01:04multiplied by 1000 and surrounded by round function and ran function will be the
01:10first argument and the second argument will be 2 which is gonna denote our sense
01:16close parenthesis and then now hold ctrl and press enter this will show you a
01:21number ranging between 1 to 1000 for before the decimal place and we'll have
01:28two decimal place numbers here now to make this into a currency simply go to
01:33currency here and then after that is done
Comments