What’s the Difference between INT, TRUNC, and ROUND?

ByRick

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…

The Cowboy Function ROUNDUP, and its Pals ROUNDDOWN, ROUND and MROUND

ByRick

Nothing to do with Cowboys really (nor Monsanto either), just couldn’t resist the pun. ROUND(number, num_digits) rounds to the nearest digit (up or down as required)ROUNDUP(number, num_digits) always rounds up* to the nearest digitROUNDDOWN(number, num_digits) always rounds down* to the nearest digit The functions take the following arguments: Number (required): Any real number that you…