Kč
-
Kč
$
$(
)
$-
£
-
£
£
-
£
£
-
£
£
-
£
£
-
£
(
)
(
)
£
-
£
£
-
£
Kč
-
Kč
Kč
-
Kč
Kč
-
Kč
Kč
-
Kč
€
-
€
€
-
€
€
-
€
€
-
€
-
-
€
-
€
- €
-
-
€
-
€
-
€
:
:
:
:
$
($
)
$
($
)
$
($
)
$
($
)
(
)
-
$
$
(
)
$
-
(
)
-
$
$
(
)
$
-
Yes
Yes
No
True
True
False
On
On
Off
€
(
€
)
\
\-
\
\-
\
\-
\
\-
\
\
-
\
-
-
-
\
\
-
\
-
-
-
-
-
-
-
-
-
€
-
€
.
/
€
-
€
⌀
$
-
$
(
)
-
$
$(
)
$-
(
)
-
$
€
-
€
.
.
WAHR
WAHR
FALSCH
/
/
-
-
-
-
:
:
:
:
:
:
/
/
:
(
)
(
)
(
)
(
)
(
)
(
)
(
)
(
)
(
)
-
(
)
-
(
)
-
(
)
-
.
.
:
:
:
.
.
:
-
-
-
-
€
-
€
€
-
€
€
-
€
€
-
€
%
:
:
:
:
:
:
-
$
-
$
???
Page 1
??? (???)
00/00/0000, 00:00:00
Page 1 / 99
BITAND Function
Result
TRUE
Sheet
Result
Description
1
TRUE
Simple BITAND formulas with local references and values
Function
Expected
Correct
FunctionString
Comment
2
2
TRUE
=BITAND(6,10)
1
1
TRUE
=BITAND(1,5)
25
9
9
TRUE
=BITAND(13,25)
Chyba:511
error
TRUE
=BITAND(25)
Chyba:502
error
TRUE
=BITAND(-13,25)
Chyba:511
error
TRUE
=BITAND(25)
0
0
TRUE
=BITAND(25,)
0
0
TRUE
=BITAND(J1,J2)
0
0
TRUE
=BITAND(J2,J3)
BITANDSummary: Returns bitwise “and” of its parametersSyntax: BITAND( Integer X ; Integer Y )Returns: NumberConstraints: X ≥ 0, Y ≥ 0Semantics: Returns bitwise “and” of its parameters. In the result, each bit position is 1 if and only if all parameters' bits at that position are also 1; else it is 0.
4
O5