How to Use Excel - MROUND Function

Excel 2007 Excel 2003 Macros Excel 2007 Macros Excel 2003 Excel 2010




I wish to calculate 5% of 32530. I know the equation in a cell =32350*5% will give me the result but I need to have the result which is a multiple of 10 in the upper range for tax purposes. How do I do that in Excel?
We make use of the MROUND() Function to solve this problem in MS Excel.
The MROUND function in MS Excel returns a number rounded to the desired multiple.

Watch the video below to learn how to use Excel's function:

Excel 2007 Excel 2003 Macros Excel 2007 Macros Excel 2003 Excel 2010