format logical values

  • Thread starter Thread starter KRK
  • Start date Start date
K

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
 
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
 
One way is to add a zero. Copy an empty cell.
Then right-click on the col > paste special > Add > ok
 
Back
Top