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
Hi sharad,
look attached..it may Help you...
--
*Best Regards,*
*Venkat*
*
*
On Sun, Jul 17, 2011 at 5:22 PM, sharad jain jainshar...@gmail.com 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,
Use
=ROUND(B12,-1) // (Suppose the number is in B12)
Cheers
Andy
On Sun, Jul 17, 2011 at 5:22 PM, sharad jain jainshar...@gmail.com 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
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 jainshar...@gmail.com wrote:
Hi Guys,
Can someone please send me a simple code for round off to nearest
Dear Sharad,
You can use MROUND function.
=MROUND(23,10)
On Sun, Jul 17, 2011 at 2:52 PM, sharad jain jainshar...@gmail.com 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
Dear Sir,
You pl use the formula
=ROUND(A1,-1)
On Sun, Jul 17, 2011 at 5:22 PM, sharad jain jainshar...@gmail.com 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