[AI] Round off in MS Excel

Pranav Lal pranav.lal at gmail.com
Mon Aug 6 20:26:38 EDT 2007


You need to use the ground function.  If I remember correctly, the syntax is
as follows.
=round(number to be rounded,decimal places)


-----Original Message-----
From: accessindia-bounces at accessindia.org.in
[mailto:accessindia-bounces at accessindia.org.in] On Behalf Of Abdul Razique
Sent: Monday, August 06, 2007 9:30 PM
To: accessindia at accessindia.org.in
Subject: [AI] Round off in MS Excel

Hello Friends,
I want to round off a number in MS Excel but I also want two decimal
places after that which will obviously be .00. For example- 1884.46
should become 1884.00 whereas 1884.70 should become 1885.00. I want
this to be done automatically as I am preparing a lenghthy
calculation. Please help me, its urgent.

Expecting a solution.

To unsubscribe send a message to accessindia-request at accessindia.org.in with
the subject unsubscribe.

To change your subscription to digest mode or make any other changes, please
visit the list home page at

More information about the AccessIndia mailing list