Kč
-
Kč
$
$(
)
$-
£
-
£
£
-
£
£
-
£
£
-
£
£
-
£
(
)
(
)
£
-
£
£
-
£
Kč
-
Kč
Kč
-
Kč
Kč
-
Kč
Kč
-
Kč
€
-
€
€
-
€
€
-
€
€
-
€
-
-
€
-
€
- €
-
-
€
-
€
-
€
:
:
:
:
$
($
)
$
($
)
$
($
)
$
($
)
(
)
-
$
$
(
)
$
-
(
)
-
$
$
(
)
$
-
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