Step-by-Step Guide to Excel Rounding Functions
Join me in this comprehensive guide to rounding functions in Excel. Discover the two main types: rounding to decimals and rounding to multiples. Learn how to apply these functions effectively with dates, times, currencies, and percentages. By the end of this video, you'll have mastered Excel's rounding functions inside out!
0:00 - Intro
0:59 - Round to a specific amount of decimals
3:06 - Round to a multiple
5:46 - The difference between rounding and changing decimal digits through font
8:31 - Rounding with time values
9:16 - Rounding a number to a quarter
Dutch translation of the functions used in this video:
=ROUND - =AFRONDEN
=ROUNDDOWN - =AFRONDEN.NAAR.BENEDEN
=ROUNDUP - =AFRONDEN.NAAR.BOVEN
=MROUND - =AFRONDEN.N.VEELVOUD
=CEILING - =AFRONDEN.BOVEN
=FLOOR - =AFRONDEN.BENEDEN
