Excel VBA to round off Numbers to nearest 10, 100, 1000, and rounding decimals to 2 places

This Excel VBA Tutorial explains Rounding off numbers, rounding of decimals using VBA Code.
You can learn how to use Round, RoundUp, RoundDown and MRound function in Excel VBA.

[@feliperibeiromoura9796]

Thank's sir, I spent three days trying to solve this problem.

[@loganmauricio8832]

Not sure if you guys cares but if you are stoned like me during the covid times you can stream all of the new series on instaflixxer. I've been streaming with my brother for the last couple of weeks =)

[@kamryneverett7184]

@Logan Mauricio yup, I've been watching on instaflixxer for since december myself :D

[@luismorujao9447]

THANK YOU SIR! SAVED MY LIFE

[@ExcelDestination]

Welcome

[@aescuder66]

Muchas gracias !!, muy útil !!

[@vijaysahal4556]

superb sir 👍🏻👍🏻👍🏻👍🏻👍🏻

[@ExcelDestination]

Thank you!

[@renas412]

Thanks

[@ExcelDestination]

Welcome

[@kareemmostafa7294]

Hi sir i want a code to round value to nearst up 0.5 value
Example
If value is 1.1 the result be 1.5
If value be 1.4 the result be 1.5
If value be 1.5 the result is same 1.5
If value 1.6 the result is 2
And also
if value is 1.35677 the result be 1.5 for example and so on
Thanks for advance

[@ExcelDestination]

Let me check

[@kareemmostafa7294]

I'm waiting

[@PiyushMedicalKnowledge]

Excel file download link