how to put yes or no in excel

Learn How to Add Yes/No in Excel

By Andrew Wilson
AD

Ever found yourself needing to present data in a binary format, such as Yes/No or True/False, in Excel? While Excel doesn't have a built-in Yes/No data type, you can certainly create this functionality with simple tricks. Let's explore how to put Yes or No in Excel using various methods.

Before we dive in, remember that Excel isn't case-sensitive, so 'YES', 'Yes', 'yes', and 'no' will all be treated the same. For consistency, we'll use 'Yes' and 'No' throughout this guide.

Using Excel's IF Function

The IF function is a staple in Excel, allowing you to make decisions based on conditions. To create a Yes/No column, this function is just what you need.

AD
Color coding Yes or No drop-down list in Excel
Color coding Yes or No drop-down list in Excel
3 Quick Ways on How To Create A List In Excel!
3 Quick Ways on How To Create A List In Excel!
How to Use IF Statement with Yes or No in Excel (3 Examples) - ExcelDemy
How to Use IF Statement with Yes or No in Excel (3 Examples) - ExcelDemy

Here's how to use it:

Setting Up the IF Function

Assuming your data is in Column A (A2:A100), enter this formula in cell B2: `=IF(A2,"Yes","No")`. This tells Excel to display "Yes" if there's data in cell A2, and "No" if it's empty.

How to Create a Yes - No Drop Down in Excel
How to Create a Yes - No Drop Down in Excel
How to Create a Yes - No Drop Down in Excel
How to Create a Yes - No Drop Down in Excel

Drag this formula down to B100, and Excel will automatically repeat it. Now you have a column of Yes/No responses based on data availability.

Using a Condition

You can also use a condition instead of data presence. For instance, if you want to show 'Yes' if Column A has '1' and 'No' if it has '0', use: `=IF(A2=1,"Yes","No")`. This will display 'Yes' only when cell A2 equals '1'.

AD

Using Excel'sвалат Function

Starting with Excel 2016, you can use the CHOOSE function for a more straightforward approach. It allows you to select an item from a list based on a specified index number.

Here's how it works:

Setting Up the CHOOSE Function

Using the same assumptions as above, enter this formula in cell B2: `=CHOOSE(A2,"Yes","No")`. This tells Excel to choose 'Yes' if cell A2 has any data, and 'No' if it's empty.

AD

Again, drag this formula down to B100 for your Yes/No column.

Now you've learned how to create a Yes/No column in Excel using two different methods. Happy calculating!

AD