Thanks for your infinite wisdom, I shall bear that in mind when asking questions here. I do usually work for myself, but in this case was meerly curious about the formula rather than wanting to accomplish something specific. Instead of opening an Excel file, entering values and then entering the formula, I just shot a mail to the list. An yes/no answer would have sufficed instead of this lecture.
----- Original Message ----- From: "Chaodhari, Sanjeev IN BOM SISL" <[EMAIL PROTECTED]> To: "Geetha Shamanna" <[EMAIL PROTECTED]>; <[email protected]> Sent: Tuesday, August 07, 2007 2:10 PM Subject: RE: [AI] Round off in MS Excel 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
