Excel Forum
Similar Content
CHOOSE Function in Excel
Tutorial: Return a value from a list of values. This is like a mini-lookup function that contains a...
Excel Function to Remove All Text OR All Numbers from a Cell
Tutorial: How to create and use a function that removes all text or all numbers from a cell, whichev...
Guide to Referencing Other Excel Files with Formulas and Functions
Tutorial: Your guide to making cross-workbook formulas and functions. This includes an overview of p...
Excel VBA Course
Excel VBA Course - From Beginner to Expert

200+ Video Lessons
50+ Hours of Video
200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course



Excel Magic Trick 392: CHOOSE function Randomly Generate 1, 0 or Blank


See how to randomly generate 1, 0 or blank with CHOOSE function and the RAND, RANDBETWEEN and INT function. Learn about the INT / RAND formula and how to get exactly the random numbers that you want.





Got a Question? Ask it Here in the Forum.