PhpSpreadsheet/tests/data/Calculation/Statistical/AVERAGEIF.php

54 lines
960 B
PHP
Raw Permalink Normal View History

<?php
return [
[
14000,
[7000, 14000, 21000, 28000],
2020-05-18 04:49:57 +00:00
'<23000',
],
[
150000,
[100000, 200000, 300000, 400000],
2020-05-18 04:49:57 +00:00
'<250000',
],
[
'#DIV/0!',
[100000, 200000, 300000, 400000],
2020-05-18 04:49:57 +00:00
'<95000',
],
[
24500,
[100000, 200000, 300000, 400000],
2020-05-18 04:49:57 +00:00
'>250000',
[7000, 14000, 21000, 28000],
],
[
8.2,
[2012, 2012, 2013, 2011, 2011, 2010],
2012,
[6, 10.4, 7, 12, 8, 15],
],
[
10,
[2012, 2012, 2013, 2011, 2011, 2010],
2011,
[6, 10.4, 7, 12, 8, 15],
],
[
7.8,
[2012, 2012, 2013, 2011, 2011, 2010],
2020-05-18 04:49:57 +00:00
'>=2012',
[6, 10.4, 7, 12, 8, 15],
],
[
2011.2,
[2012, 2012, 2013, 2011, 2011, 2010],
2020-05-18 04:49:57 +00:00
'<2013',
],
[
14000,
[7000, 14000, 'Hello World', 21000, 28000],
2020-05-18 04:49:57 +00:00
'<23000',
],
];