[AI] Round off in MS Excel

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


Hi,

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

Pranav  

-----Original Message-----
From: accessindia-bounces at accessindia.org.in
[mailto:accessindia-bounces at accessindia.org.in] On Behalf Of Abdul Razique
Khan
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.
Thanks,
Abdul

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
  http://accessindia.org.in/mailman/listinfo/accessindia_accessindia.org.in





More information about the AccessIndia mailing list