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...
Reference Other Excel Files with Formulas and Functions
Tutorial: In Excel you can use formulas and functions to reference data that is stored in another Ex...

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.