Dear Gautam jee, no problem about obtaining percentage. But the problem is with the condition that upto 5 lakhs its 10%. For the remaining value, that is 2 lakhs its 20%. How should I give the formula? I didn't know how to use conditions. Kindly enlighten me in using conditions. Thanks.
On 20/03/2015, Him Prasad Gautam <[email protected]> wrote: > hi, > In your case, just write the percentage calculation formula as in Mr. > surya's example at both B5 and b6 cell. However, you have to use the > validation feature to generate the value in either cell at one time. > In your case, If one cell has value, the other must be blank and vice > versa. If you want one cell with the desired value and the other with > zero value, then no need to use the validation option. > > > On 3/20/15, Giri Prasad <[email protected]> wrote: >> Dear Gautam and Mukesh, >> I require a formula that suits my needs. >> Suppose B4 contains the value 700000 that is 7 lakhs, I want 10% of B4 >> to be displayed in B5. But here is a condition that upto 500000 its >> 10%. For the remaining value its 20%. This 20% should be in the cell >> B6. Hope you understood my point clearly. >> Kindly help me in this conditioning formula. >> Thanks in anticipation. >> >> >> >> >> On 20/03/2015, Surya Prakash Sharma <[email protected]> wrote: >>> 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.. >>> >> >> >> -- >> WITH REGARDS >> >> GIRIPRASAD >> >> MOBILE 924710000 / 9441133367 >> >> SKYPE giriprasad.maddina >> >> "Our greatest glory consists not in never falling, >> but in rising every time we fall." >> >> >> >> 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.. > -- WITH REGARDS GIRIPRASAD MOBILE 924710000 / 9441133367 SKYPE giriprasad.maddina "Our greatest glory consists not in never falling, but in rising every time we fall." 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..
