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 <mgiriprasadma...@gmail.com> 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 <spsharma.gc...@gmail.com> 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 <drishtibac...@gmail.com> 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 <spsharma.gc...@gmail.com> 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 <mukeshbaviskar....@gmail.com> 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" <spsharma.gc...@gmail.com> >>>>> Sent: Tuesday, March 17, 2015 5:14 PM >>>>> To: "accessindia" <accessindia@accessindia.org.in> >>>>> 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/accessindia@accessindia.org.in/ >>>>>> >>>>>> To unsubscribe send a message to >>>>>> accessindia-requ...@accessindia.org.in >>>>>> 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/accessindia@accessindia.org.in/ >>>>> >>>>> To unsubscribe send a message to >>>>> accessindia-requ...@accessindia.org.in >>>>> 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/accessindia@accessindia.org.in/ >>>> >>>> To unsubscribe send a message to >>>> accessindia-requ...@accessindia.org.in >>>> 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/accessindia@accessindia.org.in/ >>> >>> To unsubscribe send a message to >>> accessindia-requ...@accessindia.org.in >>> 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/accessindia@accessindia.org.in/ >> >> To unsubscribe send a message to >> accessindia-requ...@accessindia.org.in >> 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/accessindia@accessindia.org.in/ > > To unsubscribe send a message to > accessindia-requ...@accessindia.org.in > 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/accessindia@accessindia.org.in/ To unsubscribe send a message to accessindia-requ...@accessindia.org.in 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..
