PHPOffice /
PhpSpreadsheet
| @@ 2296-2321 (lines=26) @@ | ||
| 2293 | * |
|
| 2294 | * @return float |
|
| 2295 | */ |
|
| 2296 | public static function MAXA() |
|
| 2297 | { |
|
| 2298 | $returnValue = null; |
|
| 2299 | ||
| 2300 | // Loop through arguments |
|
| 2301 | $aArgs = Functions::flattenArray(func_get_args()); |
|
| 2302 | foreach ($aArgs as $arg) { |
|
| 2303 | // Is it a numeric value? |
|
| 2304 | if ((is_numeric($arg)) || (is_bool($arg)) || ((is_string($arg) && ($arg != '')))) { |
|
| 2305 | if (is_bool($arg)) { |
|
| 2306 | $arg = (int) $arg; |
|
| 2307 | } elseif (is_string($arg)) { |
|
| 2308 | $arg = 0; |
|
| 2309 | } |
|
| 2310 | if ((is_null($returnValue)) || ($arg > $returnValue)) { |
|
| 2311 | $returnValue = $arg; |
|
| 2312 | } |
|
| 2313 | } |
|
| 2314 | } |
|
| 2315 | ||
| 2316 | if (is_null($returnValue)) { |
|
| 2317 | return 0; |
|
| 2318 | } |
|
| 2319 | ||
| 2320 | return $returnValue; |
|
| 2321 | } |
|
| 2322 | ||
| 2323 | /** |
|
| 2324 | * MAXIF. |
|
| @@ 2460-2485 (lines=26) @@ | ||
| 2457 | * |
|
| 2458 | * @return float |
|
| 2459 | */ |
|
| 2460 | public static function MINA() |
|
| 2461 | { |
|
| 2462 | $returnValue = null; |
|
| 2463 | ||
| 2464 | // Loop through arguments |
|
| 2465 | $aArgs = Functions::flattenArray(func_get_args()); |
|
| 2466 | foreach ($aArgs as $arg) { |
|
| 2467 | // Is it a numeric value? |
|
| 2468 | if ((is_numeric($arg)) || (is_bool($arg)) || ((is_string($arg) && ($arg != '')))) { |
|
| 2469 | if (is_bool($arg)) { |
|
| 2470 | $arg = (int) $arg; |
|
| 2471 | } elseif (is_string($arg)) { |
|
| 2472 | $arg = 0; |
|
| 2473 | } |
|
| 2474 | if ((is_null($returnValue)) || ($arg < $returnValue)) { |
|
| 2475 | $returnValue = $arg; |
|
| 2476 | } |
|
| 2477 | } |
|
| 2478 | } |
|
| 2479 | ||
| 2480 | if (is_null($returnValue)) { |
|
| 2481 | return 0; |
|
| 2482 | } |
|
| 2483 | ||
| 2484 | return $returnValue; |
|
| 2485 | } |
|
| 2486 | ||
| 2487 | /** |
|
| 2488 | * MINIF. |
|
