You this
=MROUND(C1,10)
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of sharad jain
Sent: Sunday, July 17, 2011 5:22 PM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Simple Code
Hi Guys,
Can someone please send me a simple code
Dear Sir,
You pl use the formula
=ROUND(A1,-1)
On Sun, Jul 17, 2011 at 5:22 PM, sharad jain wrote:
> Hi Guys,
>
> Can someone please send me a simple code for round off to nearest 10? (No
> macro if possible.)
>
> For example, if I put 23 in A1, it should result in 20 in B1 and if I put
>
Dear Sharad,
You can use MROUND function.
=MROUND(23,10)
On Sun, Jul 17, 2011 at 2:52 PM, sharad jain wrote:
> Hi Guys,
>
> Can someone please send me a simple code for round off to nearest 10? (No
> macro if possible.)
>
> For example, if I put 23 in A1, it should result in 20 in B1 and if I
Dear Sharad,
Use the following formula in B1.
=IF(VALUE(RIGHT(A1,1))<=5,FLOOR(A1,10),CEILING(A1,10))
Regards,
Marieswaran.
+971 55 9828492
On Sun, Jul 17, 2011 at 3:52 PM, sharad jain wrote:
> Hi Guys,
>
> Can someone please send me a simple code for round off to nearest 10? (No
> macro if p
Use
=ROUND(B12,-1) // (Suppose the number is in B12)
Cheers
Andy
On Sun, Jul 17, 2011 at 5:22 PM, sharad jain wrote:
> Hi Guys,
>
> Can someone please send me a simple code for round off to nearest 10? (No
> macro if possible.)
>
> For example, if I put 23 in A1, it should result in 20 in B1 an
Hi sharad,
look attached..it may Help you...
--
*Best Regards,*
*Venkat*
*
*
On Sun, Jul 17, 2011 at 5:22 PM, sharad jain wrote:
> Hi Guys,
>
> Can someone please send me a simple code for round off to nearest 10? (No
> macro if possible.)
>
> For example, if I put 23 in A1, it should result
Hi Guys,
Can someone please send me a simple code for round off to nearest 10? (No
macro if possible.)
For example, if I put 23 in A1, it should result in 20 in B1 and if I put 27
in A1, it should result in 30 in B1. For 25, it should result in 30.
Thanks in advance.
Best,
Sharad
--
-