Google Spreadsheet: how to convert the value of a cell from TRUE/FALSE to 1/0

Question

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?

E.g.

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

=D2>0.5

Answer 1

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.

Replace

=D2>0.5

with

=(D2>0.5)*1