PhpSpreadsheet/tests/data/Calculation/MathTrig/CEILING.php

105 lines
1.4 KiB
PHP
Raw Permalink Normal View History

<?php
// number, significance, result
return [
[
3.0,
2.5,
1,
],
[
-4.0,
-2.5,
-2,
],
[
1.5,
1.5,
0.10000000000000001,
],
[
0.23999999999999999,
0.23400000000000001,
0.01,
],
[
-2.3999999999999999,
-2.3410000000000002,
-0.10000000000000001,
],
[
0.0,
8,
0,
],
[
9.0,
8,
1.5,
],
[
'#NUM!',
8,
-1.5,
],
[
'#NUM!',
-8,
1.5,
],
[
-9.0,
-8,
-1.5,
],
[
8.3000000000000007,
8.2599999999999998,
0.050000000000000003,
],
[
2.3500000000000001,
2.3410000000000002,
0.050000000000000003,
],
[
'#VALUE!',
123.456,
],
[
'#VALUE!',
'PhpSpreadsheet',
],
[
211.0,
210.66999999999999,
1,
],
[
210.69999999999999,
210.66999999999999,
0.050000000000000003,
],
[
210.65000000000001,
210.63,
0.050000000000000003,
],
[
4.0,
2.98,
2,
],
[
'#NUM!',
-2.98,
2,
],
[
-5.0,
-4.5,
-1,
],
];