How to Use Excel – MROUND Function
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: