Hi Gautam jee, yes your understanding is correct. That is what I required. I want 10% and 20% to be shown in different cells. Not in one cell. Thanks a lot for yor help.
On 21/03/2015, Him Prasad Gautam <[email protected]> wrote: > 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.. > -- 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..
