Hello, thanks for the support. I was asking for the third option you mentioned and as I have mentioned earlier that formula suggested by Mukesh does the job. thanks again.
On 3/18/15, Him Prasad Gautam <[email protected]> wrote: > Though there is no trick; but there are different ways of percentage > expression. The formula differs as per format. > My key question is not yet replied. > Do you need the percentage sign automatically be written when the > value is calculated or you need just a value? > For example: > if the value is say 13 percentage. then; > what type of expression do you want? > a) 13.00% i.e the value with decimal figure and with automatically > generated percentage sign. > b) 13% i.e the value without decimal figure but with automatically > generated percentage sign. > c just 13 i.e the value without decimal figure and without the percentage > sign. > The given formula belongs to the last format option. > > > On 3/18/15, Surya Prakash Sharma <[email protected]> wrote: >> Hello, >> thanks to both of you. >> to Him Prasad Gautam: >> yes I want the figure equal to ten percent of the sum of b5 >> and c5 at d5 and the formula mentioned by Mukesh worked for that. any >> other trick if available is also requested. >> >> On 3/17/15, Mukesh Baviskar <[email protected]> wrote: >>> Hi, >>> Please try this formula: >>> in cell d5 >>> >>> =ROUND(SUM(B5,C5)*0.1,0) >>> >>> Regards, >>> Mukesh Baviskar >>> Mobile: 9403161157 >>> >>> >>> -------------------------------------------------- >>> From: "Surya Prakash Sharma" <[email protected]> >>> Sent: Tuesday, March 17, 2015 5:14 PM >>> To: "accessindia" <[email protected]> >>> Subject: [AI] Excel question. >>> >>>> Hello Accessindians, greetings of the day. >>>> >>>> my query is: how to achieve rounded 10% of B5 + C5 in cell D5. >>>> >>>> -- >>>> S. P. Sharma >>>> Lecturer, Political Science >>>> Govt. College Kaladera >>>> Jaipur >>>> >>>> >>>> >>>> Register at the dedicated AccessIndia list for discussing accessibility >>>> of >>>> >>>> mobile phones / Tabs on: >>>> http://mail.accessindia.org.in/mailman/listinfo/mobile.accessindia_accessindia.org.in >>>> >>>> >>>> Search for old postings at: >>>> http://www.mail-archive.com/[email protected]/ >>>> >>>> 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 >>>> >>>> >>>> Disclaimer: >>>> 1. Contents of the mails, factual, or otherwise, reflect the thinking >>>> of >>>> the person sending the mail and AI in no way relates itself to its >>>> veracity; >>>> >>>> 2. AI cannot be held liable for any commission/omission based on the >>>> mails >>>> >>>> sent through this mailing list.. >>> >>> >>> >>> >>> Register at the dedicated AccessIndia list for discussing accessibility >>> of >>> mobile phones / Tabs on: >>> http://mail.accessindia.org.in/mailman/listinfo/mobile.accessindia_accessindia.org.in >>> >>> >>> Search for old postings at: >>> http://www.mail-archive.com/[email protected]/ >>> >>> 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 >>> >>> >>> Disclaimer: >>> 1. Contents of the mails, factual, or otherwise, reflect the thinking of >>> the >>> person sending the mail and AI in no way relates itself to its veracity; >>> >>> 2. AI cannot be held liable for any commission/omission based on the >>> mails >>> sent through this mailing list.. >>> >> >> >> -- >> S. P. Sharma >> Lecturer, Political Science >> Govt. College Kaladera >> Jaipur >> >> >> >> Register at the dedicated AccessIndia list for discussing accessibility >> of >> mobile phones / Tabs on: >> http://mail.accessindia.org.in/mailman/listinfo/mobile.accessindia_accessindia.org.in >> >> >> Search for old postings at: >> http://www.mail-archive.com/[email protected]/ >> >> 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 >> >> >> Disclaimer: >> 1. Contents of the mails, factual, or otherwise, reflect the thinking of >> the >> person sending the mail and AI in no way relates itself to its veracity; >> >> 2. AI cannot be held liable for any commission/omission based on the >> mails >> sent through this mailing list.. >> > > > -- > Him Prasad Gautam > Kathmandu, Nepal > > > > Register at the dedicated AccessIndia list for discussing accessibility of > mobile phones / Tabs on: > http://mail.accessindia.org.in/mailman/listinfo/mobile.accessindia_accessindia.org.in > > > Search for old postings at: > http://www.mail-archive.com/[email protected]/ > > 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 > > > Disclaimer: > 1. Contents of the mails, factual, or otherwise, reflect the thinking of the > person sending the mail and AI in no way relates itself to its veracity; > > 2. AI cannot be held liable for any commission/omission based on the mails > sent through this mailing list.. > -- S. P. Sharma Lecturer, Political Science Govt. College Kaladera Jaipur Register at the dedicated AccessIndia list for discussing accessibility of mobile phones / Tabs on: http://mail.accessindia.org.in/mailman/listinfo/mobile.accessindia_accessindia.org.in Search for old postings at: http://www.mail-archive.com/[email protected]/ 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 Disclaimer: 1. Contents of the mails, factual, or otherwise, reflect the thinking of the person sending the mail and AI in no way relates itself to its veracity; 2. AI cannot be held liable for any commission/omission based on the mails sent through this mailing list..
