2016-06-25T07:16:38.437590147P0D1LibreOfficeDev/5.3.0.0.alpha0$Linux_X86_64 LibreOffice_project/eff871de05c5efdac0d0397b539b3b5e999672c9
0
0
30908
17159
view1
2
8
0
0
0
0
2
0
0
0
0
0
100
60
true
false
2
13
0
0
0
0
2
0
0
0
6
0
100
60
true
false
Sheet2
1241
0
100
60
false
true
true
true
12632256
true
true
true
true
false
false
false
1270
1270
1
1
true
false
7
false
false
true
true
false
false
false
1270
1270
true
true
true
true
true
false
12632256
false
Lexmark-E352dn
en
US
true
true
3
1
true
1
true
qQH+/0xleG1hcmstRTM1MmRuAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAQ1VQUzpMZXhtYXJrLUUzNTJkbgAAAAAAAAAAAAAAAAAWAAMAzwAAAAAAAAAEAAhSAAAEdAAASm9iRGF0YSAxCnByaW50ZXI9TGV4bWFyay1FMzUyZG4Kb3JpZW50YXRpb249UG9ydHJhaXQKY29waWVzPTEKY29sbGF0ZT1mYWxzZQptYXJnaW5kYWp1c3RtZW50PTAsMCwwLDAKY29sb3JkZXB0aD0yNApwc2xldmVsPTAKcGRmZGV2aWNlPTEKY29sb3JkZXZpY2U9MApQUERDb250ZXhEYXRhCkR1cGxleDpOb25lAElucHV0U2xvdDpUcmF5MQBQYWdlU2l6ZTpBNAAAEgBDT01QQVRfRFVQTEVYX01PREUKAERVUExFWF9PRkY=
false
0
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
CEILING.MATH Function
Result
TRUE
Sheet
Result
Description
1
TRUE
Simple CEILING.MATH formulas with local references and values
Function
Expected
Correct
FunctionString
Comment
-10
-10
TRUE
=CEILING.MATH(-11,-2)
-10
-10
TRUE
=CEILING.MATH(-11,-2,0)
25
-12
-12
TRUE
=CEILING.MATH(-11,-2,1)
3
3
TRUE
=CEILING.MATH(2.5, 1)
-2
-2
TRUE
=CEILING.MATH(-2.5, -2)
-2
-2
TRUE
=CEILING.MATH(-2.5, 2)
1.5
1.5
TRUE
=CEILING.MATH(1.5, 0.1)
0.24
0.24
TRUE
=CEILING.MATH(0.234, 0.01)
24
24
TRUE
=CEILING.MATH(J$10)
23.5
-23.5
1
24
24
TRUE
=CEILING.MATH(J$10,$L10)
0
0
0
TRUE
=CEILING.MATH(J$10,$L11)
-1
24
24
TRUE
=CEILING.MATH(J$10,$L10,0)
0
0
TRUE
=CEILING.MATH(J$10,$L11,0)
24
24
TRUE
=CEILING.MATH(J$10,$L10,1)
0
0
TRUE
=CEILING.MATH(J$10,$L11,1)
-23
-23
TRUE
=CEILING.MATH(K$10)
0
0
TRUE
=CEILING.MATH(K$10,$L11)
-23
-23
TRUE
=CEILING.MATH(K$10,$L12)
0
0
TRUE
=CEILING.MATH(K$10,$L11,0)
-23
-23
TRUE
=CEILING.MATH(K$10,$L12,0)
0
0
TRUE
=CEILING.MATH(K$10,$L11,1)
-24
-24
TRUE
=CEILING.MATH(K$10,$L12,1)
-24
-24
TRUE
=CEILING.MATH(K$10,$L10,1)
-23
-23
TRUE
=CEILING.MATH(K$10,$L10,0)
-23
-23
TRUE
=CEILING.MATH(K$10,$L10)
24
24
TRUE
=CEILING.MATH(J$10,$L12,1)
24
24
TRUE
=CEILING.MATH(J$10,$L12,0)
24
24
TRUE
=CEILING.MATH(J$10,$L12)
25
25
TRUE
=CEILING.MATH(24.3,5)
7
7
TRUE
=CEILING.MATH(6.7)
-8
-8
TRUE
=CEILING.MATH(-8.1,2)
-6
-6
TRUE
=CEILING.MATH(-5.5,2,-1)
CEILING.MATH not in help
4
O5