format logical values

[KRK]

Hello, I have Excel 2007

I have a column of logical expressions showing as TRUE or FALSE. No problem
,but can I format them to show 1 or 0 ?

Thanks

K

 

[Mike H]

Hi,

Multiply the boolean True/False by 1 to get 1 for true and 0 for false.E.G.

=(A1="")*1

Returns 1 if A1 is empty and ) id it isn't

Mike

 

[Max]

One way is to add a zero. Copy an empty cell.
Then right-click on the col > paste special > Add > ok