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:
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]
@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