, January 5, 2012 6:08:51 AM
Subject: $$Excel-Macros$$ rounding off to nearest multiple of 10
Dear experts
I am using excel vba. I want to round off an amount to its nearest multiple of
10.
eg : 251.10 (here fraction should not be considered only the whole number
which has to be rounded off to
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
Dear experts
I am using excel vba. I want to round off an amount to its nearest
multiple of 10.
eg : 251.10 (here fraction should not be considered only the whole number
which has to be rounded off to its nearest multiple of 10 i.e. 260)
252 = 260
but 250 remains 250
Pls do reply
--
FORUM