Translations:Faq/Calc/Cells having logical formatting/3/en

    From The Document Foundation Wiki

    Sometimes, while editing formulas, one can inadvertently set a cell's format to logical (Boolean Value). Then, after one writes the final variant of the formula, sees that instead of an expected numeric value, only TRUE or FALSE is displayed in the cell. It is because any non-zero number is treated as TRUE when treated as logical value; zero is FALSE.