[AI] Round off in MS Excel

Amiyo Biswas amiyo.biswas at gmail.com
Tue Aug 7 03:28:33 EDT 2007


The formula is =round(value, NumberOfDecimalPlaces)
For instance, =round(1.23,2) yields 1.00 and =round(1.89,2) yields 2.00.

After all, it has to be put in a formula. When you put a value in the cell,
it does not automatically convert the value into founded numbers. However,
you can always apply this formula in a result cell. Say you are putting the
sum of A1:A5 in cell A6. In that case, you can enter this formula in cell

Best regards,


Cell: +91-9433464329

----- Original Message -----
From: "Abdul Razique Khan" <1988.abdul at gmail.com>
To: <accessindia at accessindia.org.in>
Sent: Tuesday, August 07, 2007 11:36 AM
Subject: Re: [AI] Round off in MS Excel

> Hello Sir,
> Can you show an example. Its very urgent.
> 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

More information about the AccessIndia mailing list