How to Make Yes 1 and No 0 in Excel (2 Effective Methods)

Steps:

=IF(C5="Yes",1,0)

Making all yes into 1 and all no into 0 in Excel will give the output as shown in the image below.

Steps:

Select all the pasted cells from D5 to D10.
Go to the Home tab >> Editing group >> Find & Select tool >> Replace.

The Find and Replace window will appear.
Go to the Replace tab.
Enter Yes in the Find what: text box and insert 1 in the Replace with: text box.
Click on the Replace All button.

In the Replace tab, enter No in the Find what: text box and enter 0 in the Replace with: text box.
Click on Replace All.

It will make 1 as yes and 0 as No in Excel as shown in the image below.

How to Make 1 as Yes and 0 as No in Excel?

Steps:

The Format Cells window will appear.
Go to the Number tab >> choose the Custom option from the Category: pane >> enter any of the following formats in the Type: text box.

[=1]"Yes";[=0]"No"

Or,

“Yes”;;”No”;

All the 1 and 0 will have Yes and No output.

Download Practice Workbook

Make Yes 1 and No 0.xlsx

[wpsm_column size=”one-half”]

[/wpsm_column] [wpsm_column size=”one-half” position=”last”]

[/wpsm_column]