In this video, we will get the different rounding functions in excel explained.
We will explain all rounding functions including ROUND, ROUNDUP, ROUNDDOWN, MROUND, CEILING, FLOOR, INT, and TRUNC functions.
we will show you how to round numbers to the nearest 10, nearest 100 or nearest 1000. All in one masterclass video!
This Excel Rounding masterclass should be your one stop shop for learning all the rounding functions in Excel!
Download rounding functions guide + example file 👇
https://tinyurl.com/4kp38mpe
00:00 Intro
01:02 ROUND() function
12:52 ROUNDUP() and ROUNDDOWN() functions
19:23 MROUND() function
25:32 FLOOR.MATH() function
32:12 CEILING.MATH() function
36:06 INT() function
38:26 TRUNC() function
42:45 Final words & wrap up
Watch more of my videos:
Building a dashboard with Power Pivot and DAX:
• Interactive Excel Dashboard with Powe...
Excel custom number formatting masterclass:
• Custom Number Format in Excel 2016 |N...
Follow us on Social Media:
Facebook: https://rb.gy/dkkyt
Twitter: https://rb.gy/rq7qq
LinkedIn: https://rb.gy/3xe3p
Instagram: https://rb.gy/srhya
TikTok: https://rb.gy/4xh6f
Website: https://rb.gy/tbii2
****My online Excel Courses****
https://www.excelbonanza.com/courses/
#rounding #roundingoffnumbers #roundingoff