First of all, for 251, the NEAREST multiple of 10 is 250, not 260.
You're wishing to round UP to the NEXT multiple of 10!
Also, you said that the "fraction should not be considered"
That would imply that:
251.0 would round to 260
but:
250. would round to 250
if that's what you're looking
Hi,
User following formula:
=MROUND(A2, 10)
Check following details for more details
http://office.microsoft.com/en-us/excel-help/round-a-number-HP003056144.aspx
Regards,
Swapnil.
On Thu, Jan 5, 2012 at 4:38 PM, Shankar Bheema wrote:
> Dear experts
>
> I am using excel vba. I want to round o
