hi giri, My understanding is exact as you stated now. use the last formula which I have suggested. Instead of calculating the possible two values at cell b5 and cell b6 separately; the sum of the both conditions can be written at a single cell too. For this write as: =if(b4>500000, 50000+round((b4-500000)*.2,0), round(b4*.1,0)) Enjoy.
On 3/21/15, Him Prasad Gautam <[email protected]> wrote: > hi, > As I understood Mr. Giri's conditionality; the value at b5 will not be > zero if the value at b4 is less than 500000. The value at b5 must be > the ten percentage of b4 up to 500000. Is it not so? > However, the formula Mr. Mukesh suggested last time gives zero value if > the value at cell b4 is less than 500000. > Further more, if my understanding is wrong and there will be zero > value at b5 if the value at b4 is less than 500000; then there is no > need to write the formula as it is written. > at cell b5, it becomes a fixed value of either zero or 50000. > Hence instead, > =if(b4=>500000, 50000) is the correct formula. > No need to write round or 500000*.1 statements any more for the known > fixed values. > If my understanding of Mr. Giri's conditionality is correct, use the > formula instead. > =round(if(b4>500000, 500000, b4)*.1, 0) > This formula will give the ten percentage value of cell b4 up to the > possible higher value of 50000. > Enjoy. > > > > > On 3/21/15, Mukesh Baviskar <[email protected]> wrote: >> Hi, >> Please see the corrected formula. >> >> =ROUND(IF(B4>=500000,500000*0.1),0) >> >> Regards, >> >> Mukesh Baviskar >> Mobile: 9403161157 >> >> >> -------------------------------------------------- >> From: "Him Prasad Gautam" <[email protected]> >> Sent: Saturday, March 21, 2015 6:06 AM >> To: "AccessIndia: a list for discussing accessibility and issues >> concerningthe disabled." <[email protected]> >> Subject: Re: [AI] Excel question. >> >>> hi, Perhaps the first formula at b5 is wrong. >>> It should be, >>> round(if(b4<500000, b4, 500000)*1,0) >>> >>> >>> On 3/21/15, Mukesh Baviskar <[email protected]> wrote: >>>> Hi Giri Prasad, >>>> For 10% in b5: >>>> >>>> =ROUND(B4*0.1,0) >>>> >>>> For 20% in b6: >>>> >>>> =ROUND(IF(B4>500000,B4-500000)*0.2,0) >>>> >>>> Hope this will solve your problem. >>>> >>>> Regards, >>>> >>>> Mukesh Baviskar >>>> Mobile: 9403161157 >>>> >>>> >>>> >>>> -------------------------------------------------- >>>> From: "Giri Prasad" <[email protected]> >>>> Sent: Friday, March 20, 2015 7:13 PM >>>> To: "AccessIndia: a list for discussing accessibility and issues >>>> concerningthe disabled." <[email protected]> >>>> Subject: Re: [AI] Excel question. >>>> >>>>> 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.. >>>> >>>> >>>> >>>> >>>> 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.. >> >> >> >> >> 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 > -- 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..
