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 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..
