If we evaluate the function, we can see that the RANDBETWEEN function returns number 1. Using the formula to get a random name from the range Insert the formula: =CHOOSE(RANDBETWEEN(1,5),"George","Matt","Ann","Sam","Jennifer")įigure 2.To apply the formula, we need to follow these steps: The values of the function are “George”, “Matt”, “Ann”, “Sam”, “Jennifer”. The result of this function is a random number between 1 and 5 which is the index_num parameter of the CHOOSE function. The parameter bottom of the RANDBETWEEN function is 1 and the top is 5. In the cell B3, we want to get a random name from the name list: “Mike”, “John”, “Lilly”, “Robert” and “Jennifer”. value1,, ,… – a list of values from which one value is returned. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |