[AI] Round off in MS Excel
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
=round(number to be rounded,decimal places)
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
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