Hi. I would like to achieve the following scenario. Please help.
I would like to pick random numbers from the following numbers only: 45, 150, 200, 125, 80
example :
A1 = should get random number from above numbers only. Can I apply randbetween function?
Thank you.
F9 to refresh
=CHOOSE(RANDBETWEEN(1,5),45,150,200,125,80)
You can choose an item from a list of items through Choose Function. You can select between 2 numbers using randbetween. Combination of these two will help you.
Please Login or Register to view this content.
If I have helped, click on the * below the post
it worked perfectly. Thank you all, for your help. I appreciated it.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks