Formulas in Excel 1 - Round Numbers in Excel with Round Function to the Nearest Decimal or Integer

Round numbers in Excel using the Round Function. You will learn how to round a number to the nearest integer, to a specified number of decimals, as well as to a specified number of integers. This is a great tutorial to view to learn how to deal with numbers in Microsoft Excel and will save you a lot of time when manipulating numbers in Excel.

Have a great day!

[JDLearningTube]

This formula is The BEST to find STT CHARGE in STOCK MARKET... Thanks a lot...

[alaashaghouri]

You helped me a lot, I wasted 1 hour trying to know how to adjust the number, with your video it take it less than 1 min, Thank you very much

[dr.mohamedaitnouh]

great video straight to the point and easy to understand. Thank you vm! I subscribed.

[gwr]

One Problem, I don't want the number to appear in a different cell, I want it to the number in a cell with the result being in the same cell.

[JJ_in_Raleigh]

Can you use the function to round an existing value in its original cell without having to create a new cell to put the rounded value in?

[janadaankumaylah]

Great video, but is there a way to round within the same cell, or do I have to insert the result in the adjacent cell? And this method requires me to do the function for each cell. This takes more time than just entering it manually. Microsoft should have an easier way for such a basic function.

[sohailanjum]

This will help me in the Mathematics examination and test.

[narensaran]

Simply & perfectly explained, great job, thank

[bijayboss]

It was very helpful. Thank u for uploading this video

[svijayiitk]

Thank you very much. You have saved me a lot of time. I wish I had seen this earlier.

[ameer_ameer]

Am really grateful! You saved my time and my life as well 🙂

[mbongiseninkosi]

You're a lifesaver, thanks alot🙏

[jamesmyrthong]

Thank You so much. I was searching for this one the whole day. 💯💯💯💯👍👍👍👍

[muralidharaacharya]

NICE VIDEO DURING PRACTICAL EXAMINATIONS

[stormking]

What do I do if I want to round up or down by (5's)? For instance, the number 13 would round up to 15 or 12.4 for round down to 10.

[dustonmeyer]

i am trying to convert kb to mb then mb to gb here is the gb formula i used =D2 /( 1024 * 1024*1024) it works but it shows up as 1234.44234543 how do i make it so it does the formula and shows up like this 1234.44 also i have over 4000 in my list how do i add kb, mb, and gb to the end of every cell in each column so it would show 1234.44 mb.

[abdulbasit]

I was searching this !ty for this video

[carmonbeene]

Do you have to have an extra column for the rounded number? that doesn't seem right? I just want it to automatically round in one column

[nidhuuuuu]

Thanks a tonne saved my time . Your explanation is very clear.

[lseh]

For calculating retails… if I have a retail come out as 13.57 … is there a formula that will help round it up to $13.59?? Same with round down.. eg $13.09 to round down to $12.99? … I need the cents to end in a 9.