boolean result format TRUE/FALSE or 0/1

[Jos vanreisen]

Using a boolean expression in Excel 2000 normally (I
think) gives a result with the format TRUE or FALSE.
However, sometimes I get the result 1 or 0.
I cannot change this by normal formatting facilities, nor
I can find a sheet option that sets this format.

Can anyone tell me what sets the output format of a
boolean and how I can control this

Thanks in advance
Jos

 

[Bernard Liengme]

It would be interesting to see an example that returns 0 or 1. The only way
I know to get this is by mixing Boolean operations with arithmetic ones. So,
for example, while =A1>3 will return TRUE or FALSE, =(A1>3)*1 will return 1
or 0.
Similarly =(A1>3)*A1 gives the same result as =IF(A1>3, A1,0).
Best wishes
Bernard