Hi,

using LibreOffice Calc 4.0.4 on Windows XP.

Cell `A1=TRUE`

, Cell `B1=FALSE`

, Cell `C1=IF(AND(A1=TRUE;B1=FALSE);FALSE;TRUE)`

but when I press Enter after typing formula in C1 Calc automatically changes formula to `=IF(AND(A1=1;B1=0);0;1)`

and the result is 0. I would like to get FALSE and not 0.

Why does Calc automatically change TRUE/FALSE to 1/0?

Thanks