Its logical.
=IF(VALUE(RIGHT(INT(A2),1))>0,INT(A2)+(10-VALUE(RIGHT(INT(A2),1))),INT(A2))
Rajan.
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Shankar Bheema
Sent: Jan/Wed/2012 04:58
To: Paul Schreiner; excel-macros@googlegroups.com
Subject: $$Excel
@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Asa Rossoff
Sent: Wednesday, January 18, 2012 3:18 PM
To: excel-macros@googlegroups.com
Subject: RE: $$Excel-Macros$$ regarding rounding off
Hello Shankar,
The closest single function would be MROUND, but it rounds up and down, and
Hello Shankar,
The closest single function would be MROUND, but it rounds up and down, and
doesn't ignore the fractional part as you specified.
See if this meets your needs:
=ROUNDUP(TRUNC(number)/10,0)*10
Asa
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
