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