How to generate random Yes or No in Excel?
In some special cases, we may want to generate random Yes or No in a range in Excel, here I will tell you some formulas to quickly generate random Yes or No in Excel.
Insert Random Data （insert random integer, date, time, string or custom list in a range.）
Excel Productivity Tools
Office Tab: Bring powerful tabs to Office (include Excel), just like Chrome, Safari, Firefox and Internet Explorer. Save you half the time, and reduce thousands of mouse clicks for you. 30-day Unlimited Free Trial
Kutools for Excel: Save 70% of your time and solve 80% Excel problems for you. 300+ advanced features designed for 1500+ work scenario, make Excel much easy and increase productivity immediately. 60-day Unlimited Free Trial
|Never need to worry about long long formulas in Excel anymore! Kutools for Excel's Auto Text can add all formulas to a group
as auto text, and liberate your brain! Click here to know Auto Text Click here to get free trial
Please select a cell and type this formula =CHOOSE(RANDBETWEEN(1,2),"Yes","No") into it, and press Enter key. If you need, you can drag the fill handle to a range to fill the formula.
Note: You also can use this formula =IF(ISODD(INT(RAND()*(100-1)+1)),"Yes","No") to generate random Yes or No.
The above two formulas cannot work in Excel 2003 or below, I introduce another formula for you.
Select a cell and type this formula =IF(RAND()<=0.5,"Yes","No") into it, then press Enter key, if you need, drag the fill handle to a range.
Tip: this formula also can be used in Excel 2007/2010/2013.
With Kutools for Excel’s Insert Random Data function, you can generate random Yes or No as you need.
|Kutools for Excel, with more than 120 handy Excel functions, enhance your working efficiency and save your working time.|
After free installing Kutools for Excel, please do as below:
1. Select a range you want to randomize Yes or No, and click Kutools > Insert > Insert Random Data. See screenshot:
2. In the Insert Random Data dialog, click Custom list tab, then click the add button, then in the popping Create Sequence dialog, type Yes,No into the text box. See screenshot:
3. Click Ok > Ok. Then the selected range has been filled with Yes or No randomly.
With Insert Random Data function of Kutools for Excel, you can generate random string, time, date and so on. Click here for more information.
Select Range Randomly(Sort Range Randomly can quickly select or sort data randomly in a range/column/row.)