Could someone help me figure this out please.
I like to randomly choose from a list of following number (2500, 5000, 7500, 10000, etc.)
but here's my problem, I need the random selection to be from these whole numbers ONLY and not anything in between ie. 2550.
could you please help me put together the function for this?
Thank you everyone.
=choose(randbetween(1,4),2500,5000,7500,10000)
Gary's Student
A simmilar solution to the one proposed by JakobshavnTo generate new numbers press button "F9"
Please Login or Register to view this content.
Alf
sia83,
Please take a moment to read the forum rules and then amend your thread title to something descriptive of your problem. Once you have done this please send me a PM and I will remove this request.
To change a Title on your post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.
If I have helped, Don't forget to add to my reputation (click on the star below the post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
Use code tags when posting your VBA code: [code] Your code here [/code]
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks