PHPOffice /
PhpSpreadsheet
| @@ 993-1008 (lines=16) @@ | ||
| 990 | * |
|
| 991 | * @return float Rounded Number |
|
| 992 | */ |
|
| 993 | public static function ROUNDUP($number, $digits) |
|
| 994 | { |
|
| 995 | $number = Functions::flattenSingleValue($number); |
|
| 996 | $digits = Functions::flattenSingleValue($digits); |
|
| 997 | ||
| 998 | if ((is_numeric($number)) && (is_numeric($digits))) { |
|
| 999 | $significance = pow(10, (int) $digits); |
|
| 1000 | if ($number < 0.0) { |
|
| 1001 | return floor($number * $significance) / $significance; |
|
| 1002 | } |
|
| 1003 | ||
| 1004 | return ceil($number * $significance) / $significance; |
|
| 1005 | } |
|
| 1006 | ||
| 1007 | return Functions::VALUE(); |
|
| 1008 | } |
|
| 1009 | ||
| 1010 | /** |
|
| 1011 | * ROUNDDOWN. |
|
| @@ 1020-1035 (lines=16) @@ | ||
| 1017 | * |
|
| 1018 | * @return float Rounded Number |
|
| 1019 | */ |
|
| 1020 | public static function ROUNDDOWN($number, $digits) |
|
| 1021 | { |
|
| 1022 | $number = Functions::flattenSingleValue($number); |
|
| 1023 | $digits = Functions::flattenSingleValue($digits); |
|
| 1024 | ||
| 1025 | if ((is_numeric($number)) && (is_numeric($digits))) { |
|
| 1026 | $significance = pow(10, (int) $digits); |
|
| 1027 | if ($number < 0.0) { |
|
| 1028 | return ceil($number * $significance) / $significance; |
|
| 1029 | } |
|
| 1030 | ||
| 1031 | return floor($number * $significance) / $significance; |
|
| 1032 | } |
|
| 1033 | ||
| 1034 | return Functions::VALUE(); |
|
| 1035 | } |
|
| 1036 | ||
| 1037 | /** |
|
| 1038 | * SERIESSUM. |
|
