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