Difference between revisions of "Manuals/calci/INT"
Jump to navigation
Jump to search
| Line 9: | Line 9: | ||
INT(number) | INT(number) | ||
| − | INT(3.6) is | + | INT() function rounds a number to the nearest integer towards zero. |
| + | |||
| + | For Example, | ||
| + | |||
| + | INT(3.6) ''returns 3'' as output. | ||
| + | INT(-2.4) ''returns -3'' as output. | ||
| + | |||
| + | INT() can be used with multiple inputs as - | ||
| + | INT(4.5,6.7,3.345,2) that ''displays 4,6,3,2 as a result''. | ||
| + | |||
| + | *If the input is non-numeric, Calci displays a NaN error message. | ||
*TRUNC() and INT() functions are somewhat similar. TRUNC() removes the fractional part of the number, where as INT() rounds the number down to nearest integer. | *TRUNC() and INT() functions are somewhat similar. TRUNC() removes the fractional part of the number, where as INT() rounds the number down to nearest integer. | ||
| Line 17: | Line 27: | ||
TRUNC(-45.1) ''returns -46'' | TRUNC(-45.1) ''returns -46'' | ||
| − | |||
| − | |||
== Examples == | == Examples == | ||
Revision as of 22:56, 26 November 2013
INT(number)
- Where number is a number to be rounded.
INT() rounds a number down to the nearest integer.
Description
INT(number)
INT() function rounds a number to the nearest integer towards zero.
For Example,
INT(3.6) returns 3 as output. INT(-2.4) returns -3 as output.
INT() can be used with multiple inputs as - INT(4.5,6.7,3.345,2) that displays 4,6,3,2 as a result.
- If the input is non-numeric, Calci displays a NaN error message.
- TRUNC() and INT() functions are somewhat similar. TRUNC() removes the fractional part of the number, where as INT() rounds the number down to nearest integer.
- INT() and TRUNC() work differently with negative numbers.
INT(-45.1) returns -45 whereas
TRUNC(-45.1) returns -46