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