Excel: How to Round using ROUND(), ROUNDUP() and ROUNDDOWN() functions

To round numbers to specific decimal places you will want to use the ROUND() function, this actually rounds the number off rather than using number formatting where it is just how it is displayed. You can also choose to round it up using ROUNDUP() and round down using, you guessed it, ROUNDDOWN(). ROUND() using conventional rounding to round up and down.
There is also the INT() function if you want to make it an integer that completely loses the decimal places, you can chose to have no decimal places with any of the three functions mentioned above. If you wan to see how INT() works I have another video here • Excel: Integer and Rou... , although I do mention how it works in this video.
This video, like many on my channel, has been created using Camtasia techsmith.z6rj...
For more tutorials see my website www.jargonfreeh...
I am an Amazon an Techsmith affiliate and might earn when purchasing from any of these links. However, this does keep my free tutorials to you going.

[@mymatemartin]

Thanks for the video. A well rounded review.

[@reginahui3413]

thank you for the video. can you share with me how i can copy the total amount from one spreadsheet (the total amount is the sum up of multiple transactions) to another one