Sunday 27 September 2015

Excel Tips - Tip 33 (Using Mround Formulae)


Hello,

Hope my excel tips are helping you out.

Here is Today’s tip for you. Hope this help you.

If ever we want to round the number upward or downward to the nearest multiple, then we can used the same by using “MROUND” Command.
This function can be used to calculate the MCA Fees for incorporating a Company as per revised fees structure .

What Does It Do ?

·         This function rounds a number up or down to the nearest multiple specified by the user.

How to use it ?

'=MROUND(NumberToRound,MultipleToUse)


For example, please check the images.




Hope the Tip is found interesting to you and the same is clear.

Looking forward for a feedback.


If any of your friend is also interested for the said excel Tips , then asked them to fill the form by clicking on the below mentioned link:


If you have something that you want to share with the group, please write to excelms.tips@gmail.com


Thanks & Regards,

CA Mohit Bansal
Excel Enthusiast


+91-9045773456

No comments:

Post a Comment