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

[@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.

[@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.

[@jakubfecik1667]

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

[@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.

[@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.

[@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! 🙏

[@km1842]

Thank you! Saved me hours of time.

[@juanminute4811]

You're a lifesaver, sir. Thank you!

[@satria044]

Brilliant tuts👍👍👍

[@thejayeshrajani309]

Thanks! Bro, Problem Solved😊🙏

[@trumpexcel]

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

[@mrdhanstube]

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

[@Rose-2105]

Thanks a lot mate. That's help a lot

[@younesfilali747]

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

[@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

[@monireachtang712]

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

[@suhanasurani2]

Thank you for the knowledge.

[@alfredopadillavillatoro2199]

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

[@Rydia_Entp]

Thank you very much sir!

[@brianx4264]

Thanks! very useful small tricks.

[@miraalfatimah]

Very informative 😊

[@PoojaKumari-tb2zc]

Saved time sir

[@LUVDEEP08]

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

[@mistacoolie8481]

Very nice. thanks!

[@noblegirl1991]

Very helpful

[@jamietube9424]

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

[@santoshroulet7004]

👌 very useful

[@SufiSakib]

Loveeee Youu Man..You saved mee

[@shekhar6400]

Thanks a lot

[@maganisaivihan6827]

excellent vedio for beginers

[@byjukannampalli2799]

Thank u very much Boss. its so useful

[@santoshroulet7004]

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

[@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?

[@railway7073]

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

[@tejaannepu439]

THANKYOU, VERY USEFULL

[@rdblogbd]

thanks a lot.

[@trizahnjeri1267]

Very helpfull thankyou...

[@desaikalpesh2916]

Thanks bro.

[@tukigrace1146]

thanks

[@banwarifageriaexcelclasses1447]

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

[@_FernandoMeza]

THANK YOU BROTHER!!

[@imvisionhoti7198]

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

[@nandithakiran9756]

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

[@umarazmat]

Thank you

[@1314varun]

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

[@juholaaksonen7455]

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

[@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

[@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 ?

[@dylannolan7454]

Thank you.

[@vrenterprises4469]

SUPER SIR.....

[@jaitravlog]

Amazing

[@dineshshah2336]

what about =round function?

[@dipsisinha2970]

Hi this is not working for less than 1 no.

[@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)

[@sudhirlolariya1949]

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

[@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.

[@-_l-_-l_-]

Does anyone know how to do this in Delphi?

[@mohammedhesham1880]

Thx

[@jaisriram7289]

Superrr

[@548697a]

thx

[@Adriaan.J.L]

Cool

[@ddggamerop744]

How i convert 25 into 52

[@santoshroulet7004]

Thank you