PHPOffice /
PhpSpreadsheet
| @@ 2200-2225 (lines=26) @@ | ||
| 2197 | * @param mixed $arg,... Data values |
|
| 2198 | * @return float |
|
| 2199 | */ |
|
| 2200 | public static function MAXA() |
|
| 2201 | { |
|
| 2202 | $returnValue = null; |
|
| 2203 | ||
| 2204 | // Loop through arguments |
|
| 2205 | $aArgs = Functions::flattenArray(func_get_args()); |
|
| 2206 | foreach ($aArgs as $arg) { |
|
| 2207 | // Is it a numeric value? |
|
| 2208 | if ((is_numeric($arg)) || (is_bool($arg)) || ((is_string($arg) && ($arg != '')))) { |
|
| 2209 | if (is_bool($arg)) { |
|
| 2210 | $arg = (integer) $arg; |
|
| 2211 | } elseif (is_string($arg)) { |
|
| 2212 | $arg = 0; |
|
| 2213 | } |
|
| 2214 | if ((is_null($returnValue)) || ($arg > $returnValue)) { |
|
| 2215 | $returnValue = $arg; |
|
| 2216 | } |
|
| 2217 | } |
|
| 2218 | } |
|
| 2219 | ||
| 2220 | if (is_null($returnValue)) { |
|
| 2221 | return 0; |
|
| 2222 | } |
|
| 2223 | ||
| 2224 | return $returnValue; |
|
| 2225 | } |
|
| 2226 | ||
| 2227 | /** |
|
| 2228 | * MAXIF |
|
| @@ 2354-2379 (lines=26) @@ | ||
| 2351 | * @param mixed $arg,... Data values |
|
| 2352 | * @return float |
|
| 2353 | */ |
|
| 2354 | public static function MINA() |
|
| 2355 | { |
|
| 2356 | $returnValue = null; |
|
| 2357 | ||
| 2358 | // Loop through arguments |
|
| 2359 | $aArgs = Functions::flattenArray(func_get_args()); |
|
| 2360 | foreach ($aArgs as $arg) { |
|
| 2361 | // Is it a numeric value? |
|
| 2362 | if ((is_numeric($arg)) || (is_bool($arg)) || ((is_string($arg) && ($arg != '')))) { |
|
| 2363 | if (is_bool($arg)) { |
|
| 2364 | $arg = (integer) $arg; |
|
| 2365 | } elseif (is_string($arg)) { |
|
| 2366 | $arg = 0; |
|
| 2367 | } |
|
| 2368 | if ((is_null($returnValue)) || ($arg < $returnValue)) { |
|
| 2369 | $returnValue = $arg; |
|
| 2370 | } |
|
| 2371 | } |
|
| 2372 | } |
|
| 2373 | ||
| 2374 | if (is_null($returnValue)) { |
|
| 2375 | return 0; |
|
| 2376 | } |
|
| 2377 | ||
| 2378 | return $returnValue; |
|
| 2379 | } |
|
| 2380 | ||
| 2381 | /** |
|
| 2382 | * MINIF |
|
