Round Values to the Nearest 5, 10, 25, or…Anything in Excel
16.8 هزار بار بازدید -
2 سال پیش
-
Do you want to round
Do you want to round everything to the nearest 5? The equation in this video can do that. The nearest 10? No problem. How about the nearest 37.52? Sure. Why not.
In this video, we start by building an equation that rounds to any multiple of any number. This is similar to the MROUND function. We then go beyond what the MROUND function can do by adding the capability to either round up or down to the nearest number.
Thanks for watching.
🎬 YOUTUBE LINKS 🎬
————————————
Work Faster in Excel with These 10 Essential Keyboard Shortcuts: Work Faster in Excel with These 10 Es...
⏱ TIMESTAMPS ⏱
————————————
0:00 Introduction
0:44 Rounding to Nearest Value
2:46 Additional Examples
4:02 Rounding Up / Rounding Down
4:43 Wrap up
In this video, we start by building an equation that rounds to any multiple of any number. This is similar to the MROUND function. We then go beyond what the MROUND function can do by adding the capability to either round up or down to the nearest number.
Thanks for watching.
🎬 YOUTUBE LINKS 🎬
————————————
Work Faster in Excel with These 10 Essential Keyboard Shortcuts: Work Faster in Excel with These 10 Es...
⏱ TIMESTAMPS ⏱
————————————
0:00 Introduction
0:44 Rounding to Nearest Value
2:46 Additional Examples
4:02 Rounding Up / Rounding Down
4:43 Wrap up
2 سال پیش
در تاریخ 1401/01/10 منتشر شده
است.
16,852
بـار بازدید شده