How to Round Numbers to the Nearest Integer or 0 5 or 5 or 10 in Excel

[@Adriaan.J.L]

8:41 I agree with you on that. Ceiling and floor is just a bit simpler rather than using -1 for 10 and -2 for 100 etc.

[@bluepiphany]

Amazing!! Just what I was looking for. I was working on my spreadsheets and needed something like the ceiling function. Your explanations are quick and easy to catch. You are just great!! 👏👏Thanks a million.

[@l31007]

Very well explained. This helped so much. I didn't know you can double click the black cross to autofill the cells below. I've been dragging down for years.

[@QFour]

Thank you so much! I've been trying to figure this out for two days. Got your e-book and going to get started on it. Thanks again! 🙏

[@jakubfecik1667]

Thanks for the video! It is amazing how such a simple function can make someone´s work so much easier.

[@MySpreadsheetLab]

Very helpful video Sumit. MROUND is my favorite rounding function. Thanks for creating this video!

[@repogaming5640]

Thank you it helped me fully! all in one what I was looking for.

[@thejayeshrajani309]

Thanks! Bro, Problem Solved😊🙏

[@trumpexcel]

This is the best comment I can get. Glad the video helped 😊

[@younesfilali747]

Thanks a lot... you saved my life.... Thumb up

[@km1842]

Thank you! Saved me hours of time.

[@juanminute4811]

You're a lifesaver, sir. Thank you!

[@mrdhanstube]

thanx buddy i was always trying to find the rounding to .5 ...... cheers

[@LUVDEEP08]

Thanx Sir, you had solved my problem. Dil se thanx

[@satria044]

Brilliant tuts👍👍👍

[@Rose-2105]

Thanks a lot mate. That's help a lot

[@jackmatatula3333]

Very good tutorial. How to use that kind of function to combine using IF function, let say if result of 2.2 => 2, 2.3 up to 2.5 => 2.5, and 2.6 up to 3=> 3 in a cell. Thank you.

[@sofiacantador2646]

@trumpexcel can you please make a video on this topic?

[@alfredopadillavillatoro2199]

thanks for the video it really helped me out a lot thanks man

[@monireachtang712]

This is very useful! Thank you a lot for sharing!

[@muddassarali5495]

Awesome. Have seen this video after watching video from lyda and i feel like you explain it in much easier and logical way......two thumbs up for you

[@suhanasurani2]

Thank you for the knowledge.

[@brianx4264]

Thanks! very useful small tricks.

[@jamietube9424]

Thank you so much. I got tired by remembering this formula. It is very useful.

[@railway7073]

But i need an extra row for this. how can i do it on same row?

[@nandithakiran9756]

Hey what about for #7 it should round it off to 10, if I used this mround it will round of to 5

[@sudhirlolariya1949]

Hello sir, nice tutorial 👍 but... some mistake I found, Please check formula used in D column. It is wrong.

[@miraalfatimah]

Very informative 😊

[@PoojaKumari-tb2zc]

Saved time sir

[@banwarifageriaexcelclasses1447]

it is nice tutorial thanks...pls what is difference between float and interger value ?

[@Rydia_Entp]

Thank you very much sir!

[@santoshroulet7004]

Excellent sir, you taught in the way, which was easy to understand.

[@juholaaksonen7455]

This saved me approx ROUNDUP(7,5;10,0) Asperines.

[@amitvyas2771]

In nearest 10 sheet, 270 didn't converted to even number which might be 280 or 260 ? is there any possibility to do this ?

[@1314varun]

Hi. I want to round negative numbers to nearest 50. How can that be done? Thanks.

[@mistacoolie8481]

Very nice. thanks!

[@maganisaivihan6827]

excellent vedio for beginers

[@-_l-_-l_-]

Does anyone know how to do this in Delphi?

[@dineshshah2336]

what about =round function?

[@noblegirl1991]

Very helpful

[@liberta4112]

When you didn't listen to your teacher when it was the online lessons and the school is tmr and you have to do your worksheets

[@imvisionhoti7198]

Still unable to figure out the difference between Roundup vs Ceiling and Rounddown vs Floor

[@SufiSakib]

Loveeee Youu Man..You saved mee

[@santoshroulet7004]

👌 very useful

[@rajeshshah6758]

Sir, What is the formula to round a number to 2 decimal places. ? Say my calculated number by formula is 40.7395 should display in the formula bar as 40.74. Just like in your video column (FTE needed). It should display the amount 40.74 instead of the formula.

[@tresojos]

ROUND(CELLNR,2)

[@byjukannampalli2799]

Thank u very much Boss. its so useful

[@wanasaraf9124]

Hi, I am unable to get my desired decimal number after doing an average of 4 cells. The average number gives me an unwanted decimal number. E.g First, I want .00 to .24 as the round number (Like: The average is 112.15, which should be 112.00), Then, .24 to .75 as .50 (Like: The average is 112.34, which should be 112.50), Finally, .76 to .99 as the next rounded number (Like: The average is 112.82, which should be 113.00). It would be a great favor, if you reply me with the formula for this problem. Have a great day. Thank you.

[@_FernandoMeza]

THANK YOU BROTHER!!

[@dipsisinha2970]

Hi this is not working for less than 1 no.

[@shekhar6400]

Thanks a lot

[@tejaannepu439]

THANKYOU, VERY USEFULL

[@rdblogbd]

thanks a lot.

[@trizahnjeri1267]

Very helpfull thankyou...

[@desaikalpesh2916]

Thanks bro.

[@umarazmat]

Thank you

[@vrenterprises4469]

SUPER SIR.....

[@dylannolan7454]

Thank you.

[@jaisriram7289]

Superrr

[@jaitravlog]

Amazing

[@tukigrace1146]

thanks

[@ddggamerop744]

How i convert 25 into 52

[@mohammedhesham1880]

Thx

[@548697a]

thx

[@Adriaan.J.L]

Cool

[@santoshroulet7004]

Thank you