| @@ 2158-2183 (lines=26) @@ | ||
| 2155 | * @param mixed $arg,... Data values |
|
| 2156 | * @return float |
|
| 2157 | */ |
|
| 2158 | public static function MAXA() { |
|
| 2159 | // Return value |
|
| 2160 | $returnValue = null; |
|
| 2161 | ||
| 2162 | // Loop through arguments |
|
| 2163 | $aArgs = PHPExcel_Calculation_Functions::flattenArray(func_get_args()); |
|
| 2164 | foreach ($aArgs as $arg) { |
|
| 2165 | // Is it a numeric value? |
|
| 2166 | if ((is_numeric($arg)) || (is_bool($arg)) || ((is_string($arg) && ($arg != '')))) { |
|
| 2167 | if (is_bool($arg)) { |
|
| 2168 | $arg = (integer) $arg; |
|
| 2169 | } elseif (is_string($arg)) { |
|
| 2170 | $arg = 0; |
|
| 2171 | } |
|
| 2172 | if ((is_null($returnValue)) || ($arg > $returnValue)) { |
|
| 2173 | $returnValue = $arg; |
|
| 2174 | } |
|
| 2175 | } |
|
| 2176 | } |
|
| 2177 | ||
| 2178 | // Return |
|
| 2179 | if(is_null($returnValue)) { |
|
| 2180 | return 0; |
|
| 2181 | } |
|
| 2182 | return $returnValue; |
|
| 2183 | } // function MAXA() |
|
| 2184 | ||
| 2185 | ||
| 2186 | /** |
|
| @@ 2320-2345 (lines=26) @@ | ||
| 2317 | * @param mixed $arg,... Data values |
|
| 2318 | * @return float |
|
| 2319 | */ |
|
| 2320 | public static function MINA() { |
|
| 2321 | // Return value |
|
| 2322 | $returnValue = null; |
|
| 2323 | ||
| 2324 | // Loop through arguments |
|
| 2325 | $aArgs = PHPExcel_Calculation_Functions::flattenArray(func_get_args()); |
|
| 2326 | foreach ($aArgs as $arg) { |
|
| 2327 | // Is it a numeric value? |
|
| 2328 | if ((is_numeric($arg)) || (is_bool($arg)) || ((is_string($arg) && ($arg != '')))) { |
|
| 2329 | if (is_bool($arg)) { |
|
| 2330 | $arg = (integer) $arg; |
|
| 2331 | } elseif (is_string($arg)) { |
|
| 2332 | $arg = 0; |
|
| 2333 | } |
|
| 2334 | if ((is_null($returnValue)) || ($arg < $returnValue)) { |
|
| 2335 | $returnValue = $arg; |
|
| 2336 | } |
|
| 2337 | } |
|
| 2338 | } |
|
| 2339 | ||
| 2340 | // Return |
|
| 2341 | if(is_null($returnValue)) { |
|
| 2342 | return 0; |
|
| 2343 | } |
|
| 2344 | return $returnValue; |
|
| 2345 | } // function MINA() |
|
| 2346 | ||
| 2347 | ||
| 2348 | /** |
|