hi, your condition is not clear. I understand it as: up to 5 lakh at b4, 10% and should be written at b5, it is clear. but what you mean for b6 value. what do you mean? if the value at b4 is more than five lakh then should the percentage be twenty and be written at b6 or the twenty percentage of just remaining value i.e. deducting five lakh first and calculate? Similarly, i have given the three types of format in Surya's question. Make it clear that In which format do you need the result? The format determines the formula syntax. In excel, For expressing the condition the 'if' command is used as under. =if(value condition result one, result two) if the value meets the condition, it will write the result1 otherwise it writes the result2. for example: the mark obtained by a student at a exam is written at cell b2 and the result be written at cell c2. you should write the formula at c2 as: =if(b2<30, "fail", "pass") in the example, if a student gets a mark less than thirty, the "fail" word will be written. at cell c2. If the mark obtained is equal or more than 30, the word "pass" will be written at cell c2.
On 3/20/15, Giri Prasad <[email protected]> wrote: > 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.. > -- 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..
