AVERAGEIF.php 1.7 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384
  1. <?php
  2. return [
  3. [
  4. 14000,
  5. [7000, 14000, 21000, 28000],
  6. '<23000',
  7. ],
  8. [
  9. 150000,
  10. [100000, 200000, 300000, 400000],
  11. '<250000',
  12. ],
  13. [
  14. '#DIV/0!',
  15. [100000, 200000, 300000, 400000],
  16. '<95000',
  17. ],
  18. [
  19. 24500,
  20. [100000, 200000, 300000, 400000],
  21. '>250000',
  22. [7000, 14000, 21000, 28000],
  23. ],
  24. [
  25. 8.2,
  26. [2012, 2012, 2013, 2011, 2011, 2010],
  27. 2012,
  28. [6, 10.4, 7, 12, 8, 15],
  29. ],
  30. [
  31. 10,
  32. [2012, 2012, 2013, 2011, 2011, 2010],
  33. 2011,
  34. [6, 10.4, 7, 12, 8, 15],
  35. ],
  36. [
  37. 7.8,
  38. [2012, 2012, 2013, 2011, 2011, 2010],
  39. '>=2012',
  40. [6, 10.4, 7, 12, 8, 15],
  41. ],
  42. [
  43. 2011.2,
  44. [2012, 2012, 2013, 2011, 2011, 2010],
  45. '<2013',
  46. ],
  47. [
  48. 200,
  49. [7000, 14000, 21000, 28000],
  50. '<23000',
  51. [100, 200, 300, 800],
  52. ],
  53. [
  54. (2 + 4 + 8) / 3,
  55. [true, true, false, true, false],
  56. true,
  57. [2, 4, 6, 8, 10],
  58. ],
  59. [
  60. (6 + 10) / 2,
  61. [true, true, false, true, false],
  62. '<>true',
  63. [2, 4, 6, 8, 10],
  64. ],
  65. [
  66. (1 + 2 + 5 + 6) / 4,
  67. ['North', 'South', 'East', 'West', 'North', 'South', 'East', 'West'],
  68. '???th',
  69. [1, 2, 3, 4, 5, 6, 7, 8],
  70. ],
  71. [
  72. 16733.5,
  73. ['East', 'West', 'North', 'South (New Office)', 'Midwest'],
  74. '=*West',
  75. [45678, 23789, -4789, 0, 9678],
  76. ],
  77. [
  78. 18589,
  79. ['East', 'West', 'North', 'South (New Office)', 'Midwest'],
  80. '<>*(New Office)',
  81. [45678, 23789, -4789, 0, 9678],
  82. ],
  83. ];