[AI] Round off in MS Excel

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


Hello,

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
A6:
=round(sum(a1:a5),2)


Best regards,

Amiyo.

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





More information about the AccessIndia mailing list