![]() Calc will recognize the logical value, display it in uppercase letters, and change the cell's format to that appropriate to Boolean values.Ĭalc functions that produce a logical result return a number, either 0 or 1. To enter a logical value into a cell, simply type either TRUE or FALSE (case-insensitive) into the cell. To revert to displaying the number 1, repeat the process but select Number instead of Boolean Value. Notice that the number 1 is now displayed as TRUE. Then select Format ▸ Cells on the Menu bar to display the Format Cells dialog, select the Boolean Value option in the Category area of the Numbers tab, and click the OK button. For example, enter 1 in a cell that has the default general number format. General information about Calc's logical functionsįor convenience, the information in this subsection is repeated on all pages describing Calc’s logical functions.Ĭalc uses the numbers 0 (FALSE) and 1 (TRUE) to represent logical values. =IFERROR(X Y) is semantically equivalent to =IF(ISERROR(X) Y X), except that the former case is more efficient because X is only computed once. ![]() While 1/0 might be expected to generate a #DIV0! error, the division is never attempted in this case.Īdditional details: Details specific to IFERROR function For example, the formula =IFERROR(23 1/0) returns 23. The IFERROR function does not evaluate Otherwise Value if the evaluation of Then Value proceeds without an error.Value is an expression, or a reference to a cell containing an expression, that is evaluated and returned if no error is found.Īlternative Value is an expression, or a reference to a cell containing an expression, that is evaluated and returned only if an error was found during the evaluation of Value. Returns a value whose type depends on the argument selected as the return value. If an error is found, then a second argument is evaluated, and its value is returned. Evaluates one argument and if no error is found, the value of that argument is returned.
0 Comments
Leave a Reply. |