reginaldojunior /
winners
| @@ 718-739 (lines=22) @@ | ||
| 715 | * @param mixed $arg,... Data values |
|
| 716 | * @return float |
|
| 717 | */ |
|
| 718 | public static function PRODUCT() { |
|
| 719 | // Return value |
|
| 720 | $returnValue = null; |
|
| 721 | ||
| 722 | // Loop through arguments |
|
| 723 | foreach (PHPExcel_Calculation_Functions::flattenArray(func_get_args()) as $arg) { |
|
| 724 | // Is it a numeric value? |
|
| 725 | if ((is_numeric($arg)) && (!is_string($arg))) { |
|
| 726 | if (is_null($returnValue)) { |
|
| 727 | $returnValue = $arg; |
|
| 728 | } else { |
|
| 729 | $returnValue *= $arg; |
|
| 730 | } |
|
| 731 | } |
|
| 732 | } |
|
| 733 | ||
| 734 | // Return |
|
| 735 | if (is_null($returnValue)) { |
|
| 736 | return 0; |
|
| 737 | } |
|
| 738 | return $returnValue; |
|
| 739 | } // function PRODUCT() |
|
| 740 | ||
| 741 | ||
| 742 | /** |
|
| @@ 2122-2142 (lines=21) @@ | ||
| 2119 | * @param mixed $arg,... Data values |
|
| 2120 | * @return float |
|
| 2121 | */ |
|
| 2122 | public static function MAX() { |
|
| 2123 | // Return value |
|
| 2124 | $returnValue = null; |
|
| 2125 | ||
| 2126 | // Loop through arguments |
|
| 2127 | $aArgs = PHPExcel_Calculation_Functions::flattenArray(func_get_args()); |
|
| 2128 | foreach ($aArgs as $arg) { |
|
| 2129 | // Is it a numeric value? |
|
| 2130 | if ((is_numeric($arg)) && (!is_string($arg))) { |
|
| 2131 | if ((is_null($returnValue)) || ($arg > $returnValue)) { |
|
| 2132 | $returnValue = $arg; |
|
| 2133 | } |
|
| 2134 | } |
|
| 2135 | } |
|
| 2136 | ||
| 2137 | // Return |
|
| 2138 | if(is_null($returnValue)) { |
|
| 2139 | return 0; |
|
| 2140 | } |
|
| 2141 | return $returnValue; |
|
| 2142 | } // function MAX() |
|
| 2143 | ||
| 2144 | ||
| 2145 | /** |
|
| @@ 2284-2304 (lines=21) @@ | ||
| 2281 | * @param mixed $arg,... Data values |
|
| 2282 | * @return float |
|
| 2283 | */ |
|
| 2284 | public static function MIN() { |
|
| 2285 | // Return value |
|
| 2286 | $returnValue = null; |
|
| 2287 | ||
| 2288 | // Loop through arguments |
|
| 2289 | $aArgs = PHPExcel_Calculation_Functions::flattenArray(func_get_args()); |
|
| 2290 | foreach ($aArgs as $arg) { |
|
| 2291 | // Is it a numeric value? |
|
| 2292 | if ((is_numeric($arg)) && (!is_string($arg))) { |
|
| 2293 | if ((is_null($returnValue)) || ($arg < $returnValue)) { |
|
| 2294 | $returnValue = $arg; |
|
| 2295 | } |
|
| 2296 | } |
|
| 2297 | } |
|
| 2298 | ||
| 2299 | // Return |
|
| 2300 | if(is_null($returnValue)) { |
|
| 2301 | return 0; |
|
| 2302 | } |
|
| 2303 | return $returnValue; |
|
| 2304 | } // function MIN() |
|
| 2305 | ||
| 2306 | ||
| 2307 | /** |
|
