Microsoft Excel functions banner image.

Excel’s TRUNC function simply cuts any and all decimals off a number leaving you with an integer. There is only one argument for the TRUNC function: a reference to the cell containing the number to be truncated. There is no calculation involved, the decimals are simply chopped off.

In this post:

  1. Maths
  2. They look the same
  3. But they ain’t the same

1. Maths

I am no maths whizz. In my day I took standard grade maths in Matric which I suspect was Maths with all the difficult stuff taken out — I think it was probably easier than Maths Lit, to be honest. In this exercise, we do need to understand how we round numbers off.

“Put simply, if the last digit is less than 5, round the previous digit down. However, if it’s 5 or more then you should round the previous digit up. So, if the number you are about to round is followed by 5, 6, 7, 8, 9 round the number up. And if it is followed by 0, 1, 2, 3, 4 round the number down.”

How to round decimals ? | Rounding Numbers Guide

2. They look the same

It is crucial to understand the difference between the following functions: TRUNC, ROUND, ROUNDDOWN and INT, even though the results may in some cases be identical.

3. But they ain’t the same

It may look at first like the TRUNC function always returns the same value as the INT function as well as the same value returned by the ROUND and the ROUNDDOWN function the second arguments of ROUND and ROUNDDOWN are 0 (zero). You will see below that this is not true when we look at negative numbers!


Reference:

  1. https://support.microsoft.com/en-us/office/trunc-function-8b86a64c-3127-43db-ba14-aa5ceb292721

By MisterFoxOnline

CAT Educator

Leave a Reply

Your email address will not be published.

This site uses Akismet to reduce spam. Learn how your comment data is processed.