PHPOffice /
PhpSpreadsheet
| @@ 426-440 (lines=15) @@ | ||
| 423 | * |
|
| 424 | * @return int Integer value |
|
| 425 | */ |
|
| 426 | public static function INT($number) |
|
| 427 | { |
|
| 428 | $number = Functions::flattenSingleValue($number); |
|
| 429 | ||
| 430 | if (is_null($number)) { |
|
| 431 | return 0; |
|
| 432 | } elseif (is_bool($number)) { |
|
| 433 | return (int) $number; |
|
| 434 | } |
|
| 435 | if (is_numeric($number)) { |
|
| 436 | return (int) floor($number); |
|
| 437 | } |
|
| 438 | ||
| 439 | return Functions::VALUE(); |
|
| 440 | } |
|
| 441 | ||
| 442 | /** |
|
| 443 | * LCM. |
|
| @@ 1084-1100 (lines=17) @@ | ||
| 1081 | * |
|
| 1082 | * @return int sign value |
|
| 1083 | */ |
|
| 1084 | public static function SIGN($number) |
|
| 1085 | { |
|
| 1086 | $number = Functions::flattenSingleValue($number); |
|
| 1087 | ||
| 1088 | if (is_bool($number)) { |
|
| 1089 | return (int) $number; |
|
| 1090 | } |
|
| 1091 | if (is_numeric($number)) { |
|
| 1092 | if ($number == 0.0) { |
|
| 1093 | return 0; |
|
| 1094 | } |
|
| 1095 | ||
| 1096 | return $number / abs($number); |
|
| 1097 | } |
|
| 1098 | ||
| 1099 | return Functions::VALUE(); |
|
| 1100 | } |
|
| 1101 | ||
| 1102 | /** |
|
| 1103 | * SQRTPI. |
|
