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..
