writer
2,661
edits
Changes
Jump to navigation
Jump to search
Line 17:
Line 17: + − + Line 70:
Line 71: − +
no edit summary
INT() can be used with multiple inputs as -
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''.
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.
*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.
==References==
==References==
*[http://en.wikipedia.org/wiki/Truncation TRUNC Function]
*[http://en.wikipedia.org/wiki/Rounding#Tie-breaking Rounding]