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