Hi Geetha Sorry for being harsh, but some times you have to try out certain options before asking your question in front of any forum. Probably it will save your time. I am not saying you should not ask your doubts but it will beneficial if you work for yourself. In your case I didn't even use my mind, I just pasted your e.g. given by you in excel.
=round(sum(a1:a5)*6.5,0) In A6 and gave the random decimal values in the A1:A5 And you were right. Try to understand, I am not against you. Thanks. When you don't have any choice, you have a choice to work hard. Sanjeev Email: [EMAIL PROTECTED] Or [EMAIL PROTECTED] Space: http://daarshnicsanjeev/spaces/live.com Call: +919820637390 Direct office: +9102267572118 -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Geetha Shamanna Sent: Tuesday, August 07, 2007 1:08 PM To: [email protected] Subject: Re: [AI] Round off in MS Excel Hi Amiyo, If I want to add a range of cells and then multiply it with another number and get an answer without any decimal places, will the following formula (from your example) work? =round(sum(a1:a5)*6.5,0) I do not want any decimal places in the answer; will putting 0 here take care of that?For example, if the answer is 25386.25, I want it to be rounded to 25387. Thanks, Geetha ----- Original Message ----- From: "Amiyo Biswas" <[EMAIL PROTECTED]> To: <[email protected]> Sent: Tuesday, August 07, 2007 12:58 PM Subject: Re: [AI] Round off in MS Excel 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" <[EMAIL PROTECTED]> To: <[email protected]> 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 [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.i n 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.i n 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.i n 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
