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.

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.

[Kimico]

Thank You! What would be a good Excel Formula to round down to the nearest half decimal if above a half decimal and whole number and round down to nearest whole number if under half decimal and between whole number?

Examples:
If 3.25 Convert to “3”
If 3.85 Convert to “3.5”

[reginahui]

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