On Tue, 6 Dec 2011 11:57:27 +0000, pkumar_india1966 wrote: > > >Dear Sir, Namaskar. I am trying to put the following Formulae in MSExcel > >=MROUND[{(C11+D11)*3%Round to next multiple of Ten}+ C11] > >[e.g. {(18030+4800)*3%=684.90; round to next Ten Rs.690; therefore 690+ 18030= 18720] is required. Hence what modification in this formula is required. =ROUNDUP((C11+D11)*3%,-1)+C11 Ron

Excel is part of the MS Office suite. The appropriate place to find help with Excel is @ http://answers.microsoft.com/en-usPlease remember to click Mark as Answer on the post that helps you, and to click Unmark as Answer if a marked post does not actually answer your question. This can be beneficial to other community members reading the thread.

Dear Sir, Namaskar. I am very much grateful to you for the guidance provided to me by you. I was working on this formulae for a very longtime, seeking the help from the windows help also, but was unsuccessful. Your guidance has removed my worries and I am again energised that nothing is impossible but only determination with sincere efforts is required. However, for this I am really thankful and grateful to you. yours truly, Prakash. pkumar_india1966@hotmail.com

Dear Sir, Namaskar. I am trying to put the following Formulae in MSExcel =MROUND[{(C11+D11)*3%Round to next multiple of Ten}+ C11] [e.g. {(18030+4800)*3%=684.90; round to next Ten Rs.690; therefore 690+ 18030= 18720] is required. Hence what modification in this formula is required.