format logical values
 

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

format logical values
 

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

"KRK" wrote:

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

format logical values
 

One way is to add a zero. Copy an empty cell.
Then right-click on the col paste special Add ok
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"KRK" wrote in message
...
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