What’s the Difference between INT, TRUNC, and ROUND?
The Excel functions INT, TRUNC, and ROUND all do similar things. What’s the difference? INT Truncates a number down to the nearest integer TRUNC Truncates a number towards zero. It truncates to an integer or an optional number of decimals. INT and TRUNC produce the same result with positive numbers. They differ in the way…