- $ $( ) $- £ - £ £ - £ £ - £ £ - £ £ - £ ( ) ( ) £ - £ £ - £ - - - - - - - - - - - - € - - - - : : : : $ ($ ) $ ($ ) $ ($ ) $ ($ ) ( ) - $ $ ( ) $ - ( ) - $ $ ( ) $ - Yes Yes No True True False On On Off ( ) \ \- \ \- \ \- \ \- \ \ - \ - - - \ \ - \ - - - - - - - - - - . / - $ - $ ( ) - $ $( ) $- ( ) - $ - . . / / - - - - : : : : : : / / : ( ) ( ) ( ) ( ) ( ) ( ) ( ) ( ) ( ) - ( ) - ( ) - ( ) - % : : : : : : - $ - $ ??? Page 1 ??? (???) 00/00/0000, 00:00:00 Page 1 / 99 OR Function Result TRUE Sheet Result Description 1 TRUE Simple OR formulas with local references and values Function Expected Correct FunctionString Comment FALSE FALSE TRUE =OR(0,0) #DIV/0! AA TRUE TRUE TRUE =OR(1,0) 13 AA TRUE TRUE TRUE =OR(0,1) TRUE TRUE TRUE =OR(1,1) TRUE TRUE TRUE =OR(0, 0, 0, 1) TRUE Chyba:511 error TRUE =OR() FALSE FALSE FALSE TRUE =OR(FALSE(),FALSE()) TRUE TRUE TRUE =OR(FALSE(),TRUE()) 1 TRUE TRUE TRUE =OR(TRUE(),FALSE()) #N/A TRUE TRUE TRUE =OR(TRUE(),TRUE()) 3.1415926536 #N/A error TRUE =OR(FALSE(),NA()) TRUE TRUE TRUE =OR(FALSE(),FALSE(),TRUE()) TRUE TRUE TRUE =OR(TRUE()) ORSummary: Compute logical OR of all parameters.Syntax: OR( { Logical|NumberSequenceList L }+ )Returns: LogicalConstraints: Shall have 1 or more parametersSemantics: Computes the logical OR of the parameters. If all parameters are False, it shall return False; if any are True, it shall returns True. When given one parameter, this has the effect of converting that one parameter into a Logical value. When given zero parameters, evaluators may return a Logical value or an Error.Also in array context a logical OR of all arguments is computed, range or array parameters are not evaluated as a matrix and no array is returned. This behavior is consistent with functions like SUM. To compute a logical OR of arrays per element use the + operator in array context. 4 O5