How to roundup the amount to next ten ruppes in excel

[Venkata Krishna]

Dear Friends,

I request you all kindly let me know the forumal where we can roundup the value to next rupees.

I have tried Roundup and MRound functions to get the result but I did nto get the appropreiate resut which I am looking for.

For example if I need to deduct Tax Rs. 801 to a particualrs person I wanted to add another 9 rupees with a result it should be 810/-

next one if it is 903/- it has to be 910/-

if it is 204/- it has to be 210/-

if it is 505/- it has to 510/-

As mentioned above i have tried Mround & Roundup functions for getting the result but did workout much.

In view of the above I request you all kindly help me in this regard.

Thanks,

[humdingaling]

=ROUNDUP(a1/10,0)*10

[Venkata Krishna]

Dear Friend Thank you so much it is working well...

[Debraj Roy]

Hi Venkata..

Please mark your post as solved.. if already..

9. Acknowledge the responses you receive, good or bad. If your problem is solved, please say so clearly, and mark your thread as Solved: Click Thread Tools above your first post, select "Mark your thread as Solved". Or click the Edit button on your first post in the thread, Click Go Advanced, select [SOLVED] from the Prefix dropdown, then click Save Changes. If more than two days have elapsed, the Dropdown option or Edit button will not appear -- ask a moderator to mark it.

PS: Try this one too..

Please Login or Register  to view this content.