Hello, One problem in Excel is that a lot depends on format of the cell. If you use a formula like =round(1.228,2), Excel round it up to two digits and will yield 1.23. If you use =round(1.228,0) it will show show 1. The problem is that you must format cells to display two digits if you want all your results with two decimal places. If you want results rounded of with .00, say like 1.23 as 1.00 and 1.72 as 2.00, you will have to use for formula =round(value,0) and format the cell for display with two decimal places.
I looked for custom format, but did not find any useful result. Best regards, Amiyo. Cell: +91-9433464329 ----- Original Message ----- From: "Pranav Lal" <[EMAIL PROTECTED]> To: <[email protected]> Sent: Wednesday, August 08, 2007 7:35 AM Subject: Re: [AI] Round off in MS Excel > Let us say that you have the number 123.98876526 in cell a1, > In cell b1, you would type =round(a1,2) to round off to 2 places of decimal. > > For the rest, refer to Excel's help. > > -----Original Message----- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of Abdul Razique > Khan > Sent: Tuesday, August 07, 2007 11:36 AM > To: [email protected] > 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 [EMAIL PROTECTED] 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 > > > To unsubscribe send a message to [EMAIL PROTECTED] 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 To unsubscribe send a message to [EMAIL PROTECTED] 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
