ect: $$Excel-Macros$$ regarding rounding off
Subject: reply regardingrounding off
Kind Attention: Paul Schreiner
thank you for your reply and sorry for my late response as I am out of town.
What I required is:
if a result comes to 20.60 or 20.10 (here whatever be the fraction)
it should
@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
s.com]
On Behalf Of Shankar Bheema
Sent: Wednesday, January 18, 2012 3:28 AM
To: Paul Schreiner; excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ regarding rounding off
Subject: reply regardingrounding off
Kind Attention: Paul Schreiner
thank you for your reply and sorry for my late res
Subject: reply regardingrounding off
Kind Attention: Paul Schreiner
thank you for your reply and sorry for my late response as I am out of town.
What I required is:
if a result comes to 20.60 or 20.10 (here whatever be the fraction)
it should be rounded off to 20 only
if a result comes to 21
