Round Function in Excel (ROUND, ROUNDUP, ROUNDDOWN, and MROUND)

[@hamoodnajaf5428]

Thank you, for detailed information.

[@wallstreetmojo]

Glad it was helpful!

[@apurbaoverdrive]

Thank you, But I want to dig into a bit more.
I want this :
3.5 round up to 4 but 3.9 round up to 5 . Is there any formula to execute this?

[@benjimolina6959]

Is it possible to add the round up feature to the nearest 0.5 in the cell with a formula already established? I am not great at math and I hope I am explaining myself properly. If my cell has a formula of H7/18.92 can I add the round up feature to the nearest 0.5 in the same formula/cell or does the round up need to be in a cell beside it?

[@evilspiritgamer4046]

Thanks sir 🙇

[@wallstreetmojo]

Most welcome

[@cssst5]

How do I MROUND 0.125 to 0.12? or another case like 0.0145 MROUND to 0.014? Thanks!

[@FinanceTubes]

Sir, I have taken your Financial Modelling class online.
I am trying hard to find a job or internship in this field for many months.
Can you help to get me an Internship?

[@binithkumarsingh7663]

Thanks

[@wallstreetmojo]

Thanks for watching, glad you liked it!

[@samsonkassa3963]

Camera's quality too less!!!