PHPOffice /
PhpSpreadsheet
| @@ 952-966 (lines=15) @@ | ||
| 949 | * @param int $digits Number of digits to which you want to round $number |
|
| 950 | * @return float Rounded Number |
|
| 951 | */ |
|
| 952 | public static function ROUNDUP($number, $digits) |
|
| 953 | { |
|
| 954 | $number = Functions::flattenSingleValue($number); |
|
| 955 | $digits = Functions::flattenSingleValue($digits); |
|
| 956 | ||
| 957 | if ((is_numeric($number)) && (is_numeric($digits))) { |
|
| 958 | $significance = pow(10, (int) $digits); |
|
| 959 | if ($number < 0.0) { |
|
| 960 | return floor($number * $significance) / $significance; |
|
| 961 | } else { |
|
| 962 | return ceil($number * $significance) / $significance; |
|
| 963 | } |
|
| 964 | } |
|
| 965 | ||
| 966 | return Functions::VALUE(); |
|
| 967 | } |
|
| 968 | ||
| 969 | /** |
|
| @@ 978-992 (lines=15) @@ | ||
| 975 | * @param int $digits Number of digits to which you want to round $number |
|
| 976 | * @return float Rounded Number |
|
| 977 | */ |
|
| 978 | public static function ROUNDDOWN($number, $digits) |
|
| 979 | { |
|
| 980 | $number = Functions::flattenSingleValue($number); |
|
| 981 | $digits = Functions::flattenSingleValue($digits); |
|
| 982 | ||
| 983 | if ((is_numeric($number)) && (is_numeric($digits))) { |
|
| 984 | $significance = pow(10, (int) $digits); |
|
| 985 | if ($number < 0.0) { |
|
| 986 | return ceil($number * $significance) / $significance; |
|
| 987 | } else { |
|
| 988 | return floor($number * $significance) / $significance; |
|
| 989 | } |
|
| 990 | } |
|
| 991 | ||
| 992 | return Functions::VALUE(); |
|
| 993 | } |
|
| 994 | ||
| 995 | /** |
|
