Whenever you want to test a formula or build a data model involving complex business logic, It becomes necessary to create set of sample data by yourself to work with. RANDBETWEEN function is an useful tool to generate random numbers.
syntax:
RANDBETWEEN(lower value, upper value)
Consider a scenario where 10 three digit random numbers have to be generated.
Select cell B2 and type "=RANDBETWEEN(100, 999)"
Now, drag the formula upto cell B11 to get 10 thee digit random numbers.
Random numbers change every time you refresh the sheet or workbook.
Note: This function can be used to simulate random experiments, such as tossing of coin or rolling a die. For example, use "=RANDBETWEEN(1,6)" for rolling of a die.
syntax:
RANDBETWEEN(lower value, upper value)
Consider a scenario where 10 three digit random numbers have to be generated.
Select cell B2 and type "=RANDBETWEEN(100, 999)"
Now, drag the formula upto cell B11 to get 10 thee digit random numbers.
Random numbers change every time you refresh the sheet or workbook.
Note: This function can be used to simulate random experiments, such as tossing of coin or rolling a die. For example, use "=RANDBETWEEN(1,6)" for rolling of a die.
0 comments:
Post a Comment