+4 votes
in General by (15.3k points)

I want to put boolean value (1/0) in a column depending on the value in another column. But when I write the formula, it prints TRUE/FALSE. How can I convert TRUE/FALSE to 1/0?


In cell E2, I wrote the following formula to print 1/0, but it printed TRUE/FALSE. 


1 Answer

0 votes
by (27.1k points)

If you multiply by 1, TRUE/FALSE will convert to 1/0.

In the spreadsheet, make the following change in cell E2 to print 1/0.