Populate a value in MS Excel

I have a Excel spreadsheet and I have 3 columns. column A, column B, C开发者_运维问答olumn C.

In column B if there is a value 1 then in Column C it should populate as True and if in column B value is 0 then in C it should be False. How do I do this in MS Excel

In C1 enter

=(B1 = 1)

or

=(B1 <> 0)

and duplicate it until the end of column.

You could try

=IF(B2=0, FALSE, TRUE)

As per comment request

=IF(B2=0, "0%", "100%")