SumIfsTest.php 609 B

123456789101112131415161718192021222324
  1. <?php
  2. namespace PhpOffice\PhpSpreadsheetTests\Calculation\Functions\MathTrig;
  3. use PhpOffice\PhpSpreadsheet\Calculation\Statistical;
  4. class SumIfsTest extends AllSetupTeardown
  5. {
  6. /**
  7. * @dataProvider providerSUMIFS
  8. *
  9. * @param mixed $expectedResult
  10. */
  11. public function testSUMIFS($expectedResult, ...$args): void
  12. {
  13. $result = Statistical\Conditional::SUMIFS(...$args);
  14. self::assertEqualsWithDelta($expectedResult, $result, 1E-12);
  15. }
  16. public function providerSUMIFS(): array
  17. {
  18. return require 'tests/data/Calculation/MathTrig/SUMIFS.php';
  19. }
  20. }