PHPOffice /
PhpSpreadsheet
| @@ 933-948 (lines=16) @@ | ||
| 930 | * |
|
| 931 | * @return float Rounded Number |
|
| 932 | */ |
|
| 933 | public static function ROUNDUP($number, $digits) |
|
| 934 | { |
|
| 935 | $number = Functions::flattenSingleValue($number); |
|
| 936 | $digits = Functions::flattenSingleValue($digits); |
|
| 937 | ||
| 938 | if ((is_numeric($number)) && (is_numeric($digits))) { |
|
| 939 | $significance = pow(10, (int) $digits); |
|
| 940 | if ($number < 0.0) { |
|
| 941 | return floor($number * $significance) / $significance; |
|
| 942 | } |
|
| 943 | ||
| 944 | return ceil($number * $significance) / $significance; |
|
| 945 | } |
|
| 946 | ||
| 947 | return Functions::VALUE(); |
|
| 948 | } |
|
| 949 | ||
| 950 | /** |
|
| 951 | * ROUNDDOWN. |
|
| @@ 960-975 (lines=16) @@ | ||
| 957 | * |
|
| 958 | * @return float Rounded Number |
|
| 959 | */ |
|
| 960 | public static function ROUNDDOWN($number, $digits) |
|
| 961 | { |
|
| 962 | $number = Functions::flattenSingleValue($number); |
|
| 963 | $digits = Functions::flattenSingleValue($digits); |
|
| 964 | ||
| 965 | if ((is_numeric($number)) && (is_numeric($digits))) { |
|
| 966 | $significance = pow(10, (int) $digits); |
|
| 967 | if ($number < 0.0) { |
|
| 968 | return ceil($number * $significance) / $significance; |
|
| 969 | } |
|
| 970 | ||
| 971 | return floor($number * $significance) / $significance; |
|
| 972 | } |
|
| 973 | ||
| 974 | return Functions::VALUE(); |
|
| 975 | } |
|
| 976 | ||
| 977 | /** |
|
| 978 | * SERIESSUM. |
|
