Re: [AI] Excel question.
Everything under this menu. On 3/21/15, Surya Prakash Sharma spsharma.gc...@gmail.com wrote: Hello, many many thanks to Mr. Gautam and Mr. Mukesh for the formulas. one more query in this regard: where can one look for such formulas? On 3/21/15, Him Prasad Gautam drishtibac...@gmail.com wrote: hi, Then use the formula as: at b5: =round(if(b450, b4, 50)*.1,0) at b6: =round(if(b450, (b4-50)*.2), 0) On 3/21/15, Giri Prasad mgiriprasadma...@gmail.com wrote: 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 drishtibac...@gmail.com 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(b450, 5+round((b4-50)*.2,0), round(b4*.1,0)) Enjoy. On 3/21/15, Him Prasad Gautam drishtibac...@gmail.com 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 50. The value at b5 must be the ten percentage of b4 up to 50. Is it not so? However, the formula Mr. Mukesh suggested last time gives zero value if the value at cell b4 is less than 50. Further more, if my understanding is wrong and there will be zero value at b5 if the value at b4 is less than 50; 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 5. Hence instead, =if(b4=50, 5) is the correct formula. No need to write round or 50*.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(b450, 50, b4)*.1, 0) This formula will give the ten percentage value of cell b4 up to the possible higher value of 5. Enjoy. On 3/21/15, Mukesh Baviskar mukeshbaviskar@gmail.com wrote: Hi, Please see the corrected formula. =ROUND(IF(B4=50,50*0.1),0) Regards, Mukesh Baviskar Mobile: 9403161157 -- From: Him Prasad Gautam drishtibac...@gmail.com Sent: Saturday, March 21, 2015 6:06 AM To: AccessIndia: a list for discussing accessibility and issues concerningthe disabled. accessindia@accessindia.org.in Subject: Re: [AI] Excel question. hi, Perhaps the first formula at b5 is wrong. It should be, round(if(b450, b4, 50)*1,0) On 3/21/15, Mukesh Baviskar mukeshbaviskar@gmail.com wrote: Hi Giri Prasad, For 10% in b5: =ROUND(B4*0.1,0) For 20% in b6: =ROUND(IF(B450,B4-50)*0.2,0) Hope this will solve your problem. Regards, Mukesh Baviskar Mobile: 9403161157 -- From: Giri Prasad mgiriprasadma...@gmail.com Sent: Friday, March 20, 2015 7:13 PM To: AccessIndia: a list for discussing accessibility and issues concerningthe disabled. accessindia@accessindia.org.in Subject: Re: [AI] Excel question. Dear Gautam and Mukesh, I require a formula that suits my needs. Suppose B4 contains the value 70 that is 7 lakhs, I want 10% of B4 to be displayed in B5. But here is a condition that upto 50 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
Re: [AI] Excel question.
Baviskar Mobile: 9403161157 -- From: Him Prasad Gautam drishtibac...@gmail.com Sent: Saturday, March 21, 2015 6:06 AM To: AccessIndia: a list for discussing accessibility and issues concerningthe disabled. accessindia@accessindia.org.in Subject: Re: [AI] Excel question. hi, Perhaps the first formula at b5 is wrong. It should be, round(if(b450, b4, 50)*1,0) On 3/21/15, Mukesh Baviskar mukeshbaviskar@gmail.com wrote: Hi Giri Prasad, For 10% in b5: =ROUND(B4*0.1,0) For 20% in b6: =ROUND(IF(B450,B4-50)*0.2,0) Hope this will solve your problem. Regards, Mukesh Baviskar Mobile: 9403161157 -- From: Giri Prasad mgiriprasadma...@gmail.com Sent: Friday, March 20, 2015 7:13 PM To: AccessIndia: a list for discussing accessibility and issues concerningthe disabled. accessindia@accessindia.org.in Subject: Re: [AI] Excel question. Dear Gautam and Mukesh, I require a formula that suits my needs. Suppose B4 contains the value 70 that is 7 lakhs, I want 10% of B4 to be displayed in B5. But here is a condition that upto 50 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
Re: [AI] Excel question.
. Mukesh for the formulas. one more query in this regard: where can one look for such formulas? On 3/21/15, Him Prasad Gautam drishtibac...@gmail.com wrote: hi, Then use the formula as: at b5: =round(if(b450, b4, 50)*.1,0) at b6: =round(if(b450, (b4-50)*.2), 0) On 3/21/15, Giri Prasad mgiriprasadma...@gmail.com wrote: 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 drishtibac...@gmail.com 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(b450, 5+round((b4-50)*.2,0), round(b4*.1,0)) Enjoy. On 3/21/15, Him Prasad Gautam drishtibac...@gmail.com 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 50. The value at b5 must be the ten percentage of b4 up to 50. Is it not so? However, the formula Mr. Mukesh suggested last time gives zero value if the value at cell b4 is less than 50. Further more, if my understanding is wrong and there will be zero value at b5 if the value at b4 is less than 50; 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 5. Hence instead, =if(b4=50, 5) is the correct formula. No need to write round or 50*.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(b450, 50, b4)*.1, 0) This formula will give the ten percentage value of cell b4 up to the possible higher value of 5. Enjoy. On 3/21/15, Mukesh Baviskar mukeshbaviskar@gmail.com wrote: Hi, Please see the corrected formula. =ROUND(IF(B4=50,50*0.1),0) Regards, Mukesh Baviskar Mobile: 9403161157 -- From: Him Prasad Gautam drishtibac...@gmail.com Sent: Saturday, March 21, 2015 6:06 AM To: AccessIndia: a list for discussing accessibility and issues concerningthe disabled. accessindia@accessindia.org.in Subject: Re: [AI] Excel question. hi, Perhaps the first formula at b5 is wrong. It should be, round(if(b450, b4, 50)*1,0) On 3/21/15, Mukesh Baviskar mukeshbaviskar@gmail.com wrote: Hi Giri Prasad, For 10% in b5: =ROUND(B4*0.1,0) For 20% in b6: =ROUND(IF(B450,B4-50)*0.2,0) Hope this will solve your problem. Regards, Mukesh Baviskar Mobile: 9403161157 -- From: Giri Prasad mgiriprasadma...@gmail.com Sent: Friday, March 20, 2015 7:13 PM To: AccessIndia: a list for discussing accessibility and issues concerningthe disabled. accessindia@accessindia.org.in Subject: Re: [AI] Excel question. Dear Gautam and Mukesh, I require a formula that suits my needs. Suppose B4 contains the value 70 that is 7 lakhs, I want 10% of B4 to be displayed in B5. But here is a condition that upto 50 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
Re: [AI] Excel question.
as it is written. at cell b5, it becomes a fixed value of either zero or 5. Hence instead, =if(b4=50, 5) is the correct formula. No need to write round or 50*.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(b450, 50, b4)*.1, 0) This formula will give the ten percentage value of cell b4 up to the possible higher value of 5. Enjoy. On 3/21/15, Mukesh Baviskar mukeshbaviskar@gmail.com wrote: Hi, Please see the corrected formula. =ROUND(IF(B4=50,50*0.1),0) Regards, Mukesh Baviskar Mobile: 9403161157 -- From: Him Prasad Gautam drishtibac...@gmail.com Sent: Saturday, March 21, 2015 6:06 AM To: AccessIndia: a list for discussing accessibility and issues concerningthe disabled. accessindia@accessindia.org.in Subject: Re: [AI] Excel question. hi, Perhaps the first formula at b5 is wrong. It should be, round(if(b450, b4, 50)*1,0) On 3/21/15, Mukesh Baviskar mukeshbaviskar@gmail.com wrote: Hi Giri Prasad, For 10% in b5: =ROUND(B4*0.1,0) For 20% in b6: =ROUND(IF(B450,B4-50)*0.2,0) Hope this will solve your problem. Regards, Mukesh Baviskar Mobile: 9403161157 -- From: Giri Prasad mgiriprasadma...@gmail.com Sent: Friday, March 20, 2015 7:13 PM To: AccessIndia: a list for discussing accessibility and issues concerningthe disabled. accessindia@accessindia.org.in Subject: Re: [AI] Excel question. Dear Gautam and Mukesh, I require a formula that suits my needs. Suppose B4 contains the value 70 that is 7 lakhs, I want 10% of B4 to be displayed in B5. But here is a condition that upto 50 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
Re: [AI] Excel question.
Hi sir, a thousand thanks for your patience in responding... I thought the '0' should be the effect of ELSE as we use to usually have in the IF condition. If the value of the IF statement doesn't match what action would be executed? do we need to specify what action has to take on the contrary? Is there any command like Else available in Excel? I apologise for my little knowledge in excel... Thanking you. S.Sampath Raj Rao. On 3/24/15, Him Prasad Gautam drishtibac...@gmail.com wrote: hi Rao, As per the Giri's statement, the ten percent is fixed which is calculated by the segment *.1 and the last zero after comma is for whole number (no decimal figure) result. The if condition is related only what is the value at cell B4. On 3/23/15, sampath raj rao sampath.4...@gmail.com wrote: HI Sir, Isn't that the value '0.1, 0' represent the effect of the IF cndition? Anyhow I shall try it out On 3/22/15, Him Prasad Gautam drishtibac...@gmail.com wrote: hi Rao jee, The best way is to copy the formula at B5 in a excel sheet and type the different values at b4. once type less than 50 at b4, check the value at b5; Similarly, then type 50 at b4 check the value at b5 and then repeat the process by typing greater than 50 value at b4. your doubt will be tested practically. On 3/22/15, sampath raj rao sampath.4...@gmail.com wrote: Hi Friends, could you please clarify my doubt..? at b5: =round(if(b450, b4, 50)*.1,0) atb6: =round(if(b450, (b4-50)*.2), 0) In the above formula, considering b5's value if the amount is going to exceed 5,00,000 then won't the formula reflect '0' in the cell b5 as it is as '.1,0'. can'0' be replaced with '50,000' which may be 10 % of 5 lakhs. please correct me if my understanding is wrong as I hardly use excel. On 3/22/15, Him Prasad Gautam drishtibac...@gmail.com wrote: hi Surya, Every thing is in excel itself. You have Just to know how to access and understand them. Mind that there is a separate menu called formula in excel 7 and onward. You can find Everything under this menu. On 3/21/15, Surya Prakash Sharma spsharma.gc...@gmail.com wrote: Hello, many many thanks to Mr. Gautam and Mr. Mukesh for the formulas. one more query in this regard: where can one look for such formulas? On 3/21/15, Him Prasad Gautam drishtibac...@gmail.com wrote: hi, Then use the formula as: at b5: =round(if(b450, b4, 50)*.1,0) at b6: =round(if(b450, (b4-50)*.2), 0) On 3/21/15, Giri Prasad mgiriprasadma...@gmail.com wrote: 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 drishtibac...@gmail.com 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(b450, 5+round((b4-50)*.2,0), round(b4*.1,0)) Enjoy. On 3/21/15, Him Prasad Gautam drishtibac...@gmail.com 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 50. The value at b5 must be the ten percentage of b4 up to 50. Is it not so? However, the formula Mr. Mukesh suggested last time gives zero value if the value at cell b4 is less than 50. Further more, if my understanding is wrong and there will be zero value at b5 if the value at b4 is less than 50; 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 5. Hence instead, =if(b4=50, 5) is the correct formula. No need to write round or 50*.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(b450, 50, b4)*.1, 0) This formula will give the ten percentage value of cell b4 up to the possible higher value of 5. Enjoy. On 3/21/15, Mukesh Baviskar mukeshbaviskar@gmail.com wrote: Hi, Please see the corrected formula. =ROUND(IF(B4=50,50*0.1),0) Regards, Mukesh Baviskar Mobile: 9403161157 -- From: Him Prasad Gautam drishtibac...@gmail.com Sent: Saturday, March 21, 2015 6:06 AM To: AccessIndia: a list for discussing accessibility and issues concerningthe disabled. accessindia@accessindia.org.in Subject: Re: [AI] Excel question. hi, Perhaps the first formula at b5 is wrong. It should be, round(if(b450, b4, 50)*1,0) On 3/21/15, Mukesh Baviskar mukeshbaviskar@gmail.com wrote: Hi Giri Prasad, For 10% in b5: =ROUND(B4*0.1,0) For 20% in b6: =ROUND(IF(B450,B4-50)*0.2,0) Hope this will solve your problem. Regards
Re: [AI] Excel question.
HI Sir, Isn't that the value '0.1, 0' represent the effect of the IF cndition? Anyhow I shall try it out On 3/22/15, Him Prasad Gautam drishtibac...@gmail.com wrote: hi Rao jee, The best way is to copy the formula at B5 in a excel sheet and type the different values at b4. once type less than 50 at b4, check the value at b5; Similarly, then type 50 at b4 check the value at b5 and then repeat the process by typing greater than 50 value at b4. your doubt will be tested practically. On 3/22/15, sampath raj rao sampath.4...@gmail.com wrote: Hi Friends, could you please clarify my doubt..? at b5: =round(if(b450, b4, 50)*.1,0) atb6: =round(if(b450, (b4-50)*.2), 0) In the above formula, considering b5's value if the amount is going to exceed 5,00,000 then won't the formula reflect '0' in the cell b5 as it is as '.1,0'. can'0' be replaced with '50,000' which may be 10 % of 5 lakhs. please correct me if my understanding is wrong as I hardly use excel. On 3/22/15, Him Prasad Gautam drishtibac...@gmail.com wrote: hi Surya, Every thing is in excel itself. You have Just to know how to access and understand them. Mind that there is a separate menu called formula in excel 7 and onward. You can find Everything under this menu. On 3/21/15, Surya Prakash Sharma spsharma.gc...@gmail.com wrote: Hello, many many thanks to Mr. Gautam and Mr. Mukesh for the formulas. one more query in this regard: where can one look for such formulas? On 3/21/15, Him Prasad Gautam drishtibac...@gmail.com wrote: hi, Then use the formula as: at b5: =round(if(b450, b4, 50)*.1,0) at b6: =round(if(b450, (b4-50)*.2), 0) On 3/21/15, Giri Prasad mgiriprasadma...@gmail.com wrote: 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 drishtibac...@gmail.com 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(b450, 5+round((b4-50)*.2,0), round(b4*.1,0)) Enjoy. On 3/21/15, Him Prasad Gautam drishtibac...@gmail.com 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 50. The value at b5 must be the ten percentage of b4 up to 50. Is it not so? However, the formula Mr. Mukesh suggested last time gives zero value if the value at cell b4 is less than 50. Further more, if my understanding is wrong and there will be zero value at b5 if the value at b4 is less than 50; 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 5. Hence instead, =if(b4=50, 5) is the correct formula. No need to write round or 50*.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(b450, 50, b4)*.1, 0) This formula will give the ten percentage value of cell b4 up to the possible higher value of 5. Enjoy. On 3/21/15, Mukesh Baviskar mukeshbaviskar@gmail.com wrote: Hi, Please see the corrected formula. =ROUND(IF(B4=50,50*0.1),0) Regards, Mukesh Baviskar Mobile: 9403161157 -- From: Him Prasad Gautam drishtibac...@gmail.com Sent: Saturday, March 21, 2015 6:06 AM To: AccessIndia: a list for discussing accessibility and issues concerningthe disabled. accessindia@accessindia.org.in Subject: Re: [AI] Excel question. hi, Perhaps the first formula at b5 is wrong. It should be, round(if(b450, b4, 50)*1,0) On 3/21/15, Mukesh Baviskar mukeshbaviskar@gmail.com wrote: Hi Giri Prasad, For 10% in b5: =ROUND(B4*0.1,0) For 20% in b6: =ROUND(IF(B450,B4-50)*0.2,0) Hope this will solve your problem. Regards, Mukesh Baviskar Mobile: 9403161157 -- From: Giri Prasad mgiriprasadma...@gmail.com Sent: Friday, March 20, 2015 7:13 PM To: AccessIndia: a list for discussing accessibility and issues concerningthe disabled. accessindia@accessindia.org.in Subject: Re: [AI] Excel question. Dear Gautam and Mukesh, I require a formula that suits my needs. Suppose B4 contains the value 70 that is 7 lakhs, I want 10% of B4 to be displayed in B5. But here is a condition that upto 50 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
Re: [AI] Excel question.
hi Rao, As per the Giri's statement, the ten percent is fixed which is calculated by the segment *.1 and the last zero after comma is for whole number (no decimal figure) result. The if condition is related only what is the value at cell B4. On 3/23/15, sampath raj rao sampath.4...@gmail.com wrote: HI Sir, Isn't that the value '0.1, 0' represent the effect of the IF cndition? Anyhow I shall try it out On 3/22/15, Him Prasad Gautam drishtibac...@gmail.com wrote: hi Rao jee, The best way is to copy the formula at B5 in a excel sheet and type the different values at b4. once type less than 50 at b4, check the value at b5; Similarly, then type 50 at b4 check the value at b5 and then repeat the process by typing greater than 50 value at b4. your doubt will be tested practically. On 3/22/15, sampath raj rao sampath.4...@gmail.com wrote: Hi Friends, could you please clarify my doubt..? at b5: =round(if(b450, b4, 50)*.1,0) atb6: =round(if(b450, (b4-50)*.2), 0) In the above formula, considering b5's value if the amount is going to exceed 5,00,000 then won't the formula reflect '0' in the cell b5 as it is as '.1,0'. can'0' be replaced with '50,000' which may be 10 % of 5 lakhs. please correct me if my understanding is wrong as I hardly use excel. On 3/22/15, Him Prasad Gautam drishtibac...@gmail.com wrote: hi Surya, Every thing is in excel itself. You have Just to know how to access and understand them. Mind that there is a separate menu called formula in excel 7 and onward. You can find Everything under this menu. On 3/21/15, Surya Prakash Sharma spsharma.gc...@gmail.com wrote: Hello, many many thanks to Mr. Gautam and Mr. Mukesh for the formulas. one more query in this regard: where can one look for such formulas? On 3/21/15, Him Prasad Gautam drishtibac...@gmail.com wrote: hi, Then use the formula as: at b5: =round(if(b450, b4, 50)*.1,0) at b6: =round(if(b450, (b4-50)*.2), 0) On 3/21/15, Giri Prasad mgiriprasadma...@gmail.com wrote: 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 drishtibac...@gmail.com 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(b450, 5+round((b4-50)*.2,0), round(b4*.1,0)) Enjoy. On 3/21/15, Him Prasad Gautam drishtibac...@gmail.com 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 50. The value at b5 must be the ten percentage of b4 up to 50. Is it not so? However, the formula Mr. Mukesh suggested last time gives zero value if the value at cell b4 is less than 50. Further more, if my understanding is wrong and there will be zero value at b5 if the value at b4 is less than 50; 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 5. Hence instead, =if(b4=50, 5) is the correct formula. No need to write round or 50*.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(b450, 50, b4)*.1, 0) This formula will give the ten percentage value of cell b4 up to the possible higher value of 5. Enjoy. On 3/21/15, Mukesh Baviskar mukeshbaviskar@gmail.com wrote: Hi, Please see the corrected formula. =ROUND(IF(B4=50,50*0.1),0) Regards, Mukesh Baviskar Mobile: 9403161157 -- From: Him Prasad Gautam drishtibac...@gmail.com Sent: Saturday, March 21, 2015 6:06 AM To: AccessIndia: a list for discussing accessibility and issues concerningthe disabled. accessindia@accessindia.org.in Subject: Re: [AI] Excel question. hi, Perhaps the first formula at b5 is wrong. It should be, round(if(b450, b4, 50)*1,0) On 3/21/15, Mukesh Baviskar mukeshbaviskar@gmail.com wrote: Hi Giri Prasad, For 10% in b5: =ROUND(B4*0.1,0) For 20% in b6: =ROUND(IF(B450,B4-50)*0.2,0) Hope this will solve your problem. Regards, Mukesh Baviskar Mobile: 9403161157 -- From: Giri Prasad mgiriprasadma...@gmail.com Sent: Friday, March 20, 2015 7:13 PM To: AccessIndia: a list for discussing accessibility and issues concerningthe disabled. accessindia@accessindia.org.in Subject: Re: [AI] Excel question. Dear Gautam and Mukesh, I require a formula that suits my needs. Suppose B4 contains the value 70 that is 7 lakhs, I want 10% of B4 to be displayed in B5
Re: [AI] Excel question.
hi Rao jee, The best way is to copy the formula at B5 in a excel sheet and type the different values at b4. once type less than 50 at b4, check the value at b5; Similarly, then type 50 at b4 check the value at b5 and then repeat the process by typing greater than 50 value at b4. your doubt will be tested practically. On 3/22/15, sampath raj rao sampath.4...@gmail.com wrote: Hi Friends, could you please clarify my doubt..? at b5: =round(if(b450, b4, 50)*.1,0) atb6: =round(if(b450, (b4-50)*.2), 0) In the above formula, considering b5's value if the amount is going to exceed 5,00,000 then won't the formula reflect '0' in the cell b5 as it is as '.1,0'. can'0' be replaced with '50,000' which may be 10 % of 5 lakhs. please correct me if my understanding is wrong as I hardly use excel. On 3/22/15, Him Prasad Gautam drishtibac...@gmail.com wrote: hi Surya, Every thing is in excel itself. You have Just to know how to access and understand them. Mind that there is a separate menu called formula in excel 7 and onward. You can find Everything under this menu. On 3/21/15, Surya Prakash Sharma spsharma.gc...@gmail.com wrote: Hello, many many thanks to Mr. Gautam and Mr. Mukesh for the formulas. one more query in this regard: where can one look for such formulas? On 3/21/15, Him Prasad Gautam drishtibac...@gmail.com wrote: hi, Then use the formula as: at b5: =round(if(b450, b4, 50)*.1,0) at b6: =round(if(b450, (b4-50)*.2), 0) On 3/21/15, Giri Prasad mgiriprasadma...@gmail.com wrote: 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 drishtibac...@gmail.com 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(b450, 5+round((b4-50)*.2,0), round(b4*.1,0)) Enjoy. On 3/21/15, Him Prasad Gautam drishtibac...@gmail.com 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 50. The value at b5 must be the ten percentage of b4 up to 50. Is it not so? However, the formula Mr. Mukesh suggested last time gives zero value if the value at cell b4 is less than 50. Further more, if my understanding is wrong and there will be zero value at b5 if the value at b4 is less than 50; 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 5. Hence instead, =if(b4=50, 5) is the correct formula. No need to write round or 50*.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(b450, 50, b4)*.1, 0) This formula will give the ten percentage value of cell b4 up to the possible higher value of 5. Enjoy. On 3/21/15, Mukesh Baviskar mukeshbaviskar@gmail.com wrote: Hi, Please see the corrected formula. =ROUND(IF(B4=50,50*0.1),0) Regards, Mukesh Baviskar Mobile: 9403161157 -- From: Him Prasad Gautam drishtibac...@gmail.com Sent: Saturday, March 21, 2015 6:06 AM To: AccessIndia: a list for discussing accessibility and issues concerningthe disabled. accessindia@accessindia.org.in Subject: Re: [AI] Excel question. hi, Perhaps the first formula at b5 is wrong. It should be, round(if(b450, b4, 50)*1,0) On 3/21/15, Mukesh Baviskar mukeshbaviskar@gmail.com wrote: Hi Giri Prasad, For 10% in b5: =ROUND(B4*0.1,0) For 20% in b6: =ROUND(IF(B450,B4-50)*0.2,0) Hope this will solve your problem. Regards, Mukesh Baviskar Mobile: 9403161157 -- From: Giri Prasad mgiriprasadma...@gmail.com Sent: Friday, March 20, 2015 7:13 PM To: AccessIndia: a list for discussing accessibility and issues concerningthe disabled. accessindia@accessindia.org.in Subject: Re: [AI] Excel question. Dear Gautam and Mukesh, I require a formula that suits my needs. Suppose B4 contains the value 70 that is 7 lakhs, I want 10% of B4 to be displayed in B5. But here is a condition that upto 50 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
Re: [AI] Excel question.
hi, Then use the formula as: at b5: =round(if(b450, b4, 50)*.1,0) at b6: =round(if(b450, (b4-50)*.2), 0) On 3/21/15, Giri Prasad mgiriprasadma...@gmail.com wrote: 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 drishtibac...@gmail.com 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(b450, 5+round((b4-50)*.2,0), round(b4*.1,0)) Enjoy. On 3/21/15, Him Prasad Gautam drishtibac...@gmail.com 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 50. The value at b5 must be the ten percentage of b4 up to 50. Is it not so? However, the formula Mr. Mukesh suggested last time gives zero value if the value at cell b4 is less than 50. Further more, if my understanding is wrong and there will be zero value at b5 if the value at b4 is less than 50; 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 5. Hence instead, =if(b4=50, 5) is the correct formula. No need to write round or 50*.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(b450, 50, b4)*.1, 0) This formula will give the ten percentage value of cell b4 up to the possible higher value of 5. Enjoy. On 3/21/15, Mukesh Baviskar mukeshbaviskar@gmail.com wrote: Hi, Please see the corrected formula. =ROUND(IF(B4=50,50*0.1),0) Regards, Mukesh Baviskar Mobile: 9403161157 -- From: Him Prasad Gautam drishtibac...@gmail.com Sent: Saturday, March 21, 2015 6:06 AM To: AccessIndia: a list for discussing accessibility and issues concerningthe disabled. accessindia@accessindia.org.in Subject: Re: [AI] Excel question. hi, Perhaps the first formula at b5 is wrong. It should be, round(if(b450, b4, 50)*1,0) On 3/21/15, Mukesh Baviskar mukeshbaviskar@gmail.com wrote: Hi Giri Prasad, For 10% in b5: =ROUND(B4*0.1,0) For 20% in b6: =ROUND(IF(B450,B4-50)*0.2,0) Hope this will solve your problem. Regards, Mukesh Baviskar Mobile: 9403161157 -- From: Giri Prasad mgiriprasadma...@gmail.com Sent: Friday, March 20, 2015 7:13 PM To: AccessIndia: a list for discussing accessibility and issues concerningthe disabled. accessindia@accessindia.org.in Subject: Re: [AI] Excel question. Dear Gautam and Mukesh, I require a formula that suits my needs. Suppose B4 contains the value 70 that is 7 lakhs, I want 10% of B4 to be displayed in B5. But here is a condition that upto 50 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
Re: [AI] Excel question.
Hello, many many thanks to Mr. Gautam and Mr. Mukesh for the formulas. one more query in this regard: where can one look for such formulas? On 3/21/15, Him Prasad Gautam drishtibac...@gmail.com wrote: hi, Then use the formula as: at b5: =round(if(b450, b4, 50)*.1,0) at b6: =round(if(b450, (b4-50)*.2), 0) On 3/21/15, Giri Prasad mgiriprasadma...@gmail.com wrote: 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 drishtibac...@gmail.com 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(b450, 5+round((b4-50)*.2,0), round(b4*.1,0)) Enjoy. On 3/21/15, Him Prasad Gautam drishtibac...@gmail.com 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 50. The value at b5 must be the ten percentage of b4 up to 50. Is it not so? However, the formula Mr. Mukesh suggested last time gives zero value if the value at cell b4 is less than 50. Further more, if my understanding is wrong and there will be zero value at b5 if the value at b4 is less than 50; 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 5. Hence instead, =if(b4=50, 5) is the correct formula. No need to write round or 50*.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(b450, 50, b4)*.1, 0) This formula will give the ten percentage value of cell b4 up to the possible higher value of 5. Enjoy. On 3/21/15, Mukesh Baviskar mukeshbaviskar@gmail.com wrote: Hi, Please see the corrected formula. =ROUND(IF(B4=50,50*0.1),0) Regards, Mukesh Baviskar Mobile: 9403161157 -- From: Him Prasad Gautam drishtibac...@gmail.com Sent: Saturday, March 21, 2015 6:06 AM To: AccessIndia: a list for discussing accessibility and issues concerningthe disabled. accessindia@accessindia.org.in Subject: Re: [AI] Excel question. hi, Perhaps the first formula at b5 is wrong. It should be, round(if(b450, b4, 50)*1,0) On 3/21/15, Mukesh Baviskar mukeshbaviskar@gmail.com wrote: Hi Giri Prasad, For 10% in b5: =ROUND(B4*0.1,0) For 20% in b6: =ROUND(IF(B450,B4-50)*0.2,0) Hope this will solve your problem. Regards, Mukesh Baviskar Mobile: 9403161157 -- From: Giri Prasad mgiriprasadma...@gmail.com Sent: Friday, March 20, 2015 7:13 PM To: AccessIndia: a list for discussing accessibility and issues concerningthe disabled. accessindia@accessindia.org.in Subject: Re: [AI] Excel question. Dear Gautam and Mukesh, I require a formula that suits my needs. Suppose B4 contains the value 70 that is 7 lakhs, I want 10% of B4 to be displayed in B5. But here is a condition that upto 50 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
Re: [AI] Excel question.
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 drishtibac...@gmail.com 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(b450, 5+round((b4-50)*.2,0), round(b4*.1,0)) Enjoy. On 3/21/15, Him Prasad Gautam drishtibac...@gmail.com 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 50. The value at b5 must be the ten percentage of b4 up to 50. Is it not so? However, the formula Mr. Mukesh suggested last time gives zero value if the value at cell b4 is less than 50. Further more, if my understanding is wrong and there will be zero value at b5 if the value at b4 is less than 50; 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 5. Hence instead, =if(b4=50, 5) is the correct formula. No need to write round or 50*.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(b450, 50, b4)*.1, 0) This formula will give the ten percentage value of cell b4 up to the possible higher value of 5. Enjoy. On 3/21/15, Mukesh Baviskar mukeshbaviskar@gmail.com wrote: Hi, Please see the corrected formula. =ROUND(IF(B4=50,50*0.1),0) Regards, Mukesh Baviskar Mobile: 9403161157 -- From: Him Prasad Gautam drishtibac...@gmail.com Sent: Saturday, March 21, 2015 6:06 AM To: AccessIndia: a list for discussing accessibility and issues concerningthe disabled. accessindia@accessindia.org.in Subject: Re: [AI] Excel question. hi, Perhaps the first formula at b5 is wrong. It should be, round(if(b450, b4, 50)*1,0) On 3/21/15, Mukesh Baviskar mukeshbaviskar@gmail.com wrote: Hi Giri Prasad, For 10% in b5: =ROUND(B4*0.1,0) For 20% in b6: =ROUND(IF(B450,B4-50)*0.2,0) Hope this will solve your problem. Regards, Mukesh Baviskar Mobile: 9403161157 -- From: Giri Prasad mgiriprasadma...@gmail.com Sent: Friday, March 20, 2015 7:13 PM To: AccessIndia: a list for discussing accessibility and issues concerningthe disabled. accessindia@accessindia.org.in Subject: Re: [AI] Excel question. Dear Gautam and Mukesh, I require a formula that suits my needs. Suppose B4 contains the value 70 that is 7 lakhs, I want 10% of B4 to be displayed in B5. But here is a condition that upto 50 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
Re: [AI] Excel question.
hi Surya, Every thing is in excel itself. You have Just to know how to access and understand them. Mind that there is a separate menu called formula in excel 7 and onward. You can find Everything under this menu. On 3/21/15, Surya Prakash Sharma spsharma.gc...@gmail.com wrote: Hello, many many thanks to Mr. Gautam and Mr. Mukesh for the formulas. one more query in this regard: where can one look for such formulas? On 3/21/15, Him Prasad Gautam drishtibac...@gmail.com wrote: hi, Then use the formula as: at b5: =round(if(b450, b4, 50)*.1,0) at b6: =round(if(b450, (b4-50)*.2), 0) On 3/21/15, Giri Prasad mgiriprasadma...@gmail.com wrote: 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 drishtibac...@gmail.com 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(b450, 5+round((b4-50)*.2,0), round(b4*.1,0)) Enjoy. On 3/21/15, Him Prasad Gautam drishtibac...@gmail.com 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 50. The value at b5 must be the ten percentage of b4 up to 50. Is it not so? However, the formula Mr. Mukesh suggested last time gives zero value if the value at cell b4 is less than 50. Further more, if my understanding is wrong and there will be zero value at b5 if the value at b4 is less than 50; 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 5. Hence instead, =if(b4=50, 5) is the correct formula. No need to write round or 50*.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(b450, 50, b4)*.1, 0) This formula will give the ten percentage value of cell b4 up to the possible higher value of 5. Enjoy. On 3/21/15, Mukesh Baviskar mukeshbaviskar@gmail.com wrote: Hi, Please see the corrected formula. =ROUND(IF(B4=50,50*0.1),0) Regards, Mukesh Baviskar Mobile: 9403161157 -- From: Him Prasad Gautam drishtibac...@gmail.com Sent: Saturday, March 21, 2015 6:06 AM To: AccessIndia: a list for discussing accessibility and issues concerningthe disabled. accessindia@accessindia.org.in Subject: Re: [AI] Excel question. hi, Perhaps the first formula at b5 is wrong. It should be, round(if(b450, b4, 50)*1,0) On 3/21/15, Mukesh Baviskar mukeshbaviskar@gmail.com wrote: Hi Giri Prasad, For 10% in b5: =ROUND(B4*0.1,0) For 20% in b6: =ROUND(IF(B450,B4-50)*0.2,0) Hope this will solve your problem. Regards, Mukesh Baviskar Mobile: 9403161157 -- From: Giri Prasad mgiriprasadma...@gmail.com Sent: Friday, March 20, 2015 7:13 PM To: AccessIndia: a list for discussing accessibility and issues concerningthe disabled. accessindia@accessindia.org.in Subject: Re: [AI] Excel question. Dear Gautam and Mukesh, I require a formula that suits my needs. Suppose B4 contains the value 70 that is 7 lakhs, I want 10% of B4 to be displayed in B5. But here is a condition that upto 50 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
Re: [AI] Excel question.
Hi Friends, could you please clarify my doubt..? at b5: =round(if(b450, b4, 50)*.1,0) atb6: =round(if(b450, (b4-50)*.2), 0) In the above formula, considering b5's value if the amount is going to exceed 5,00,000 then won't the formula reflect '0' in the cell b5 as it is as '.1,0'. can'0' be replaced with '50,000' which may be 10 % of 5 lakhs. please correct me if my understanding is wrong as I hardly use excel. On 3/22/15, Him Prasad Gautam drishtibac...@gmail.com wrote: hi Surya, Every thing is in excel itself. You have Just to know how to access and understand them. Mind that there is a separate menu called formula in excel 7 and onward. You can find Everything under this menu. On 3/21/15, Surya Prakash Sharma spsharma.gc...@gmail.com wrote: Hello, many many thanks to Mr. Gautam and Mr. Mukesh for the formulas. one more query in this regard: where can one look for such formulas? On 3/21/15, Him Prasad Gautam drishtibac...@gmail.com wrote: hi, Then use the formula as: at b5: =round(if(b450, b4, 50)*.1,0) at b6: =round(if(b450, (b4-50)*.2), 0) On 3/21/15, Giri Prasad mgiriprasadma...@gmail.com wrote: 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 drishtibac...@gmail.com 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(b450, 5+round((b4-50)*.2,0), round(b4*.1,0)) Enjoy. On 3/21/15, Him Prasad Gautam drishtibac...@gmail.com 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 50. The value at b5 must be the ten percentage of b4 up to 50. Is it not so? However, the formula Mr. Mukesh suggested last time gives zero value if the value at cell b4 is less than 50. Further more, if my understanding is wrong and there will be zero value at b5 if the value at b4 is less than 50; 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 5. Hence instead, =if(b4=50, 5) is the correct formula. No need to write round or 50*.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(b450, 50, b4)*.1, 0) This formula will give the ten percentage value of cell b4 up to the possible higher value of 5. Enjoy. On 3/21/15, Mukesh Baviskar mukeshbaviskar@gmail.com wrote: Hi, Please see the corrected formula. =ROUND(IF(B4=50,50*0.1),0) Regards, Mukesh Baviskar Mobile: 9403161157 -- From: Him Prasad Gautam drishtibac...@gmail.com Sent: Saturday, March 21, 2015 6:06 AM To: AccessIndia: a list for discussing accessibility and issues concerningthe disabled. accessindia@accessindia.org.in Subject: Re: [AI] Excel question. hi, Perhaps the first formula at b5 is wrong. It should be, round(if(b450, b4, 50)*1,0) On 3/21/15, Mukesh Baviskar mukeshbaviskar@gmail.com wrote: Hi Giri Prasad, For 10% in b5: =ROUND(B4*0.1,0) For 20% in b6: =ROUND(IF(B450,B4-50)*0.2,0) Hope this will solve your problem. Regards, Mukesh Baviskar Mobile: 9403161157 -- From: Giri Prasad mgiriprasadma...@gmail.com Sent: Friday, March 20, 2015 7:13 PM To: AccessIndia: a list for discussing accessibility and issues concerningthe disabled. accessindia@accessindia.org.in Subject: Re: [AI] Excel question. Dear Gautam and Mukesh, I require a formula that suits my needs. Suppose B4 contains the value 70 that is 7 lakhs, I want 10% of B4 to be displayed in B5. But here is a condition that upto 50 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
Re: [AI] Excel question.
Hi Giri Prasad, For 10% in b5: =ROUND(B4*0.1,0) For 20% in b6: =ROUND(IF(B450,B4-50)*0.2,0) Hope this will solve your problem. Regards, Mukesh Baviskar Mobile: 9403161157 -- From: Giri Prasad mgiriprasadma...@gmail.com Sent: Friday, March 20, 2015 7:13 PM To: AccessIndia: a list for discussing accessibility and issues concerningthe disabled. accessindia@accessindia.org.in Subject: Re: [AI] Excel question. Dear Gautam and Mukesh, I require a formula that suits my needs. Suppose B4 contains the value 70 that is 7 lakhs, I want 10% of B4 to be displayed in B5. But here is a condition that upto 50 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
Re: [AI] Excel question.
hi, Perhaps the first formula at b5 is wrong. It should be, round(if(b450, b4, 50)*1,0) On 3/21/15, Mukesh Baviskar mukeshbaviskar@gmail.com wrote: Hi Giri Prasad, For 10% in b5: =ROUND(B4*0.1,0) For 20% in b6: =ROUND(IF(B450,B4-50)*0.2,0) Hope this will solve your problem. Regards, Mukesh Baviskar Mobile: 9403161157 -- From: Giri Prasad mgiriprasadma...@gmail.com Sent: Friday, March 20, 2015 7:13 PM To: AccessIndia: a list for discussing accessibility and issues concerningthe disabled. accessindia@accessindia.org.in Subject: Re: [AI] Excel question. Dear Gautam and Mukesh, I require a formula that suits my needs. Suppose B4 contains the value 70 that is 7 lakhs, I want 10% of B4 to be displayed in B5. But here is a condition that upto 50 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
Re: [AI] Excel question.
Hi, Please see the corrected formula. =ROUND(IF(B4=50,50*0.1),0) Regards, Mukesh Baviskar Mobile: 9403161157 -- From: Him Prasad Gautam drishtibac...@gmail.com Sent: Saturday, March 21, 2015 6:06 AM To: AccessIndia: a list for discussing accessibility and issues concerningthe disabled. accessindia@accessindia.org.in Subject: Re: [AI] Excel question. hi, Perhaps the first formula at b5 is wrong. It should be, round(if(b450, b4, 50)*1,0) On 3/21/15, Mukesh Baviskar mukeshbaviskar@gmail.com wrote: Hi Giri Prasad, For 10% in b5: =ROUND(B4*0.1,0) For 20% in b6: =ROUND(IF(B450,B4-50)*0.2,0) Hope this will solve your problem. Regards, Mukesh Baviskar Mobile: 9403161157 -- From: Giri Prasad mgiriprasadma...@gmail.com Sent: Friday, March 20, 2015 7:13 PM To: AccessIndia: a list for discussing accessibility and issues concerningthe disabled. accessindia@accessindia.org.in Subject: Re: [AI] Excel question. Dear Gautam and Mukesh, I require a formula that suits my needs. Suppose B4 contains the value 70 that is 7 lakhs, I want 10% of B4 to be displayed in B5. But here is a condition that upto 50 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
Re: [AI] Excel question.
Hi Him Prasad Gautam, Yes, Completely agree with you. Thank you for pointing out my mistake. Have a nice day! Regards, Mukesh Baviskar Mobile: 9403161157 -- From: Him Prasad Gautam drishtibac...@gmail.com Sent: Saturday, March 21, 2015 6:06 AM To: AccessIndia: a list for discussing accessibility and issues concerningthe disabled. accessindia@accessindia.org.in Subject: Re: [AI] Excel question. hi, Perhaps the first formula at b5 is wrong. It should be, round(if(b450, b4, 50)*1,0) On 3/21/15, Mukesh Baviskar mukeshbaviskar@gmail.com wrote: Hi Giri Prasad, For 10% in b5: =ROUND(B4*0.1,0) For 20% in b6: =ROUND(IF(B450,B4-50)*0.2,0) Hope this will solve your problem. Regards, Mukesh Baviskar Mobile: 9403161157 -- From: Giri Prasad mgiriprasadma...@gmail.com Sent: Friday, March 20, 2015 7:13 PM To: AccessIndia: a list for discussing accessibility and issues concerningthe disabled. accessindia@accessindia.org.in Subject: Re: [AI] Excel question. Dear Gautam and Mukesh, I require a formula that suits my needs. Suppose B4 contains the value 70 that is 7 lakhs, I want 10% of B4 to be displayed in B5. But here is a condition that upto 50 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
Re: [AI] Excel question.
Hi Gautam and Mukesh, my requirement is similar to income tax calculation. Upto 5 lakhs its 10% and above 5 lakhs its 20%. That is in my case it is, upto 5 lakhs its 50 thousand and for the remaining value that is 7 lakhs minus 5 lakhs = 2 lakhs 20% = 40 thousand. Thanks friends. On 21/03/2015, Mukesh Baviskar mukeshbaviskar@gmail.com wrote: Hi, Please see the corrected formula. =ROUND(IF(B4=50,50*0.1),0) Regards, Mukesh Baviskar Mobile: 9403161157 -- From: Him Prasad Gautam drishtibac...@gmail.com Sent: Saturday, March 21, 2015 6:06 AM To: AccessIndia: a list for discussing accessibility and issues concerningthe disabled. accessindia@accessindia.org.in Subject: Re: [AI] Excel question. hi, Perhaps the first formula at b5 is wrong. It should be, round(if(b450, b4, 50)*1,0) On 3/21/15, Mukesh Baviskar mukeshbaviskar@gmail.com wrote: Hi Giri Prasad, For 10% in b5: =ROUND(B4*0.1,0) For 20% in b6: =ROUND(IF(B450,B4-50)*0.2,0) Hope this will solve your problem. Regards, Mukesh Baviskar Mobile: 9403161157 -- From: Giri Prasad mgiriprasadma...@gmail.com Sent: Friday, March 20, 2015 7:13 PM To: AccessIndia: a list for discussing accessibility and issues concerningthe disabled. accessindia@accessindia.org.in Subject: Re: [AI] Excel question. Dear Gautam and Mukesh, I require a formula that suits my needs. Suppose B4 contains the value 70 that is 7 lakhs, I want 10% of B4 to be displayed in B5. But here is a condition that upto 50 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
Re: [AI] Excel question.
hi, As I understood Mr. Giri's conditionality; the value at b5 will not be zero if the value at b4 is less than 50. The value at b5 must be the ten percentage of b4 up to 50. Is it not so? However, the formula Mr. Mukesh suggested last time gives zero value if the value at cell b4 is less than 50. Further more, if my understanding is wrong and there will be zero value at b5 if the value at b4 is less than 50; 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 5. Hence instead, =if(b4=50, 5) is the correct formula. No need to write round or 50*.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(b450, 50, b4)*.1, 0) This formula will give the ten percentage value of cell b4 up to the possible higher value of 5. Enjoy. On 3/21/15, Mukesh Baviskar mukeshbaviskar@gmail.com wrote: Hi, Please see the corrected formula. =ROUND(IF(B4=50,50*0.1),0) Regards, Mukesh Baviskar Mobile: 9403161157 -- From: Him Prasad Gautam drishtibac...@gmail.com Sent: Saturday, March 21, 2015 6:06 AM To: AccessIndia: a list for discussing accessibility and issues concerningthe disabled. accessindia@accessindia.org.in Subject: Re: [AI] Excel question. hi, Perhaps the first formula at b5 is wrong. It should be, round(if(b450, b4, 50)*1,0) On 3/21/15, Mukesh Baviskar mukeshbaviskar@gmail.com wrote: Hi Giri Prasad, For 10% in b5: =ROUND(B4*0.1,0) For 20% in b6: =ROUND(IF(B450,B4-50)*0.2,0) Hope this will solve your problem. Regards, Mukesh Baviskar Mobile: 9403161157 -- From: Giri Prasad mgiriprasadma...@gmail.com Sent: Friday, March 20, 2015 7:13 PM To: AccessIndia: a list for discussing accessibility and issues concerningthe disabled. accessindia@accessindia.org.in Subject: Re: [AI] Excel question. Dear Gautam and Mukesh, I require a formula that suits my needs. Suppose B4 contains the value 70 that is 7 lakhs, I want 10% of B4 to be displayed in B5. But here is a condition that upto 50 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
Re: [AI] Excel question.
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(b450, 5+round((b4-50)*.2,0), round(b4*.1,0)) Enjoy. On 3/21/15, Him Prasad Gautam drishtibac...@gmail.com 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 50. The value at b5 must be the ten percentage of b4 up to 50. Is it not so? However, the formula Mr. Mukesh suggested last time gives zero value if the value at cell b4 is less than 50. Further more, if my understanding is wrong and there will be zero value at b5 if the value at b4 is less than 50; 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 5. Hence instead, =if(b4=50, 5) is the correct formula. No need to write round or 50*.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(b450, 50, b4)*.1, 0) This formula will give the ten percentage value of cell b4 up to the possible higher value of 5. Enjoy. On 3/21/15, Mukesh Baviskar mukeshbaviskar@gmail.com wrote: Hi, Please see the corrected formula. =ROUND(IF(B4=50,50*0.1),0) Regards, Mukesh Baviskar Mobile: 9403161157 -- From: Him Prasad Gautam drishtibac...@gmail.com Sent: Saturday, March 21, 2015 6:06 AM To: AccessIndia: a list for discussing accessibility and issues concerningthe disabled. accessindia@accessindia.org.in Subject: Re: [AI] Excel question. hi, Perhaps the first formula at b5 is wrong. It should be, round(if(b450, b4, 50)*1,0) On 3/21/15, Mukesh Baviskar mukeshbaviskar@gmail.com wrote: Hi Giri Prasad, For 10% in b5: =ROUND(B4*0.1,0) For 20% in b6: =ROUND(IF(B450,B4-50)*0.2,0) Hope this will solve your problem. Regards, Mukesh Baviskar Mobile: 9403161157 -- From: Giri Prasad mgiriprasadma...@gmail.com Sent: Friday, March 20, 2015 7:13 PM To: AccessIndia: a list for discussing accessibility and issues concerningthe disabled. accessindia@accessindia.org.in Subject: Re: [AI] Excel question. Dear Gautam and Mukesh, I require a formula that suits my needs. Suppose B4 contains the value 70 that is 7 lakhs, I want 10% of B4 to be displayed in B5. But here is a condition that upto 50 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
Re: [AI] Excel question.
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 mgiriprasadma...@gmail.com wrote: Dear Gautam and Mukesh, I require a formula that suits my needs. Suppose B4 contains the value 70 that is 7 lakhs, I want 10% of B4 to be displayed in B5. But here is a condition that upto 50 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
Re: [AI] Excel question.
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
Re: [AI] Excel question.
Dear Gautam and Mukesh, I require a formula that suits my needs. Suppose B4 contains the value 70 that is 7 lakhs, I want 10% of B4 to be displayed in B5. But here is a condition that upto 50 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
Re: [AI] Excel question.
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 drishtibac...@gmail.com 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 mgiriprasadma...@gmail.com wrote: Dear Gautam and Mukesh, I require a formula that suits my needs. Suppose B4 contains the value 70 that is 7 lakhs, I want 10% of B4 to be displayed in B5. But here is a condition that upto 50 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
Re: [AI] Excel question.
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(b230, 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 mgiriprasadma...@gmail.com 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 drishtibac...@gmail.com 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 mgiriprasadma...@gmail.com wrote: Dear Gautam and Mukesh, I require a formula that suits my needs. Suppose B4 contains the value 70 that is 7 lakhs, I want 10% of B4 to be displayed in B5. But here is a condition that upto 50 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
Re: [AI] Excel question.
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
Re: [AI] Excel question.
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..
[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..
Re: [AI] Excel question.
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..
Re: [AI] Excel question.
hi, Do you mean you want the figure equal to ten percent of the sum of b5 and c5 at d5? If yes, then make further clear. Do you want the percentage sign be automatically written at d5 or just a ten percentage value in number at d5 only. I will state as per your desire of the result format. On 3/17/15, Surya Prakash Sharma spsharma.gc...@gmail.com wrote: 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.. -- 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..
Re: [AI] excel question
Dear Sanjay, Type your formula in cell D8 as follows, =round(b8+c8,0) enter this formula without quotation mark and read the formula with arrow keys thanking you. On 9/12/14, Him Prasad Gautam drishtibac...@gmail.com wrote: Perhaps you have written =round(d8,0) in d8 cell itself. Circular reference means the cell in which the formula is written falls with the refered cell within the formula. On 9/11/14, sanjay sanjaylpra...@yahoo.co.in wrote: Friends, In d8 I have 18136.5 which is sum of b8 and c8. I tried to round it to the nearest digit, that is, 18137. After typing =round(d8,0) I am getting the folowing error. Microsoft Office Excel Circular Reference Warning One or more formulas contain a circular reference and may not calculate correctly. Circular references are any references within a formula that depend upon the results of that same formula. For example, a cell that refers to its own value or a cell that refers to another cell which depends on the original cell's value both contain circular references. For more information about understanding, finding, and removing circular references, click OK. If you want to create a circular reference, click Cancel to continue. Please let me know how to write more than one formulae in a cel, and also, where I am wrong? Thanks. 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.. -- together we can and we will make the differnce Zoher 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..
Re: [AI] excel question
hi, There is next option. define d8 cell format as integer i.e. no decimal). Generally round (value,x) formula is used if x is a non zero number. formula On 9/12/14, Zoher Kheriwala zos...@gmail.com wrote: Dear Sanjay, Type your formula in cell D8 as follows, =round(b8+c8,0) enter this formula without quotation mark and read the formula with arrow keys thanking you. On 9/12/14, Him Prasad Gautam drishtibac...@gmail.com wrote: Perhaps you have written =round(d8,0) in d8 cell itself. Circular reference means the cell in which the formula is written falls with the refered cell within the formula. On 9/11/14, sanjay sanjaylpra...@yahoo.co.in wrote: Friends, In d8 I have 18136.5 which is sum of b8 and c8. I tried to round it to the nearest digit, that is, 18137. After typing =round(d8,0) I am getting the folowing error. Microsoft Office Excel Circular Reference Warning One or more formulas contain a circular reference and may not calculate correctly. Circular references are any references within a formula that depend upon the results of that same formula. For example, a cell that refers to its own value or a cell that refers to another cell which depends on the original cell's value both contain circular references. For more information about understanding, finding, and removing circular references, click OK. If you want to create a circular reference, click Cancel to continue. Please let me know how to write more than one formulae in a cel, and also, where I am wrong? Thanks. 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.. -- together we can and we will make the differnce Zoher 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
Re: [AI] excel question
Yes. That's true. I'll nest both the formula as Zoher Kheriwala suggested. Thanks to both of you. - Original Message - From: Him Prasad Gautam drishtibac...@gmail.com To: AccessIndia: a list for discussing accessibility and issues concerningthe disabled. accessindia@accessindia.org.in Sent: Friday, September 12, 2014 11:11 AM Subject: Re: [AI] excel question Perhaps you have written =round(d8,0) in d8 cell itself. Circular reference means the cell in which the formula is written falls with the refered cell within the formula. On 9/11/14, sanjay sanjaylpra...@yahoo.co.in wrote: Friends, In d8 I have 18136.5 which is sum of b8 and c8. I tried to round it to the nearest digit, that is, 18137. After typing =round(d8,0) I am getting the folowing error. Microsoft Office Excel Circular Reference Warning One or more formulas contain a circular reference and may not calculate correctly. Circular references are any references within a formula that depend upon the results of that same formula. For example, a cell that refers to its own value or a cell that refers to another cell which depends on the original cell's value both contain circular references. For more information about understanding, finding, and removing circular references, click OK. If you want to create a circular reference, click Cancel to continue. Please let me know how to write more than one formulae in a cel, and also, where I am wrong? Thanks. 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.. 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..
[AI] excel question
Friends, In d8 I have 18136.5 which is sum of b8 and c8. I tried to round it to the nearest digit, that is, 18137. After typing =round(d8,0) I am getting the folowing error. Microsoft Office Excel Circular Reference Warning One or more formulas contain a circular reference and may not calculate correctly. Circular references are any references within a formula that depend upon the results of that same formula. For example, a cell that refers to its own value or a cell that refers to another cell which depends on the original cell's value both contain circular references. For more information about understanding, finding, and removing circular references, click OK. If you want to create a circular reference, click Cancel to continue. Please let me know how to write more than one formulae in a cel, and also, where I am wrong? Thanks. 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..
Re: [AI] excel question
Perhaps you have written =round(d8,0) in d8 cell itself. Circular reference means the cell in which the formula is written falls with the refered cell within the formula. On 9/11/14, sanjay sanjaylpra...@yahoo.co.in wrote: Friends, In d8 I have 18136.5 which is sum of b8 and c8. I tried to round it to the nearest digit, that is, 18137. After typing =round(d8,0) I am getting the folowing error. Microsoft Office Excel Circular Reference Warning One or more formulas contain a circular reference and may not calculate correctly. Circular references are any references within a formula that depend upon the results of that same formula. For example, a cell that refers to its own value or a cell that refers to another cell which depends on the original cell's value both contain circular references. For more information about understanding, finding, and removing circular references, click OK. If you want to create a circular reference, click Cancel to continue. Please let me know how to write more than one formulae in a cel, and also, where I am wrong? Thanks. 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..
[AI] Excel Question.
Hello, I have macros in some excel files. Jaws 12 and 13 keep reading the cells when a macro is being executed. It makes everything very slow and clumsy. Moreover, jaws tries to say everything. I tried various options in the verbosity dialogue box. I also used insert+s to set speech mode to none. Still I could not solve my problem. Please help. It did not happen with jaws 11 or earlier versions. With best regards, Amiyo Biswas Cell: +91-9433464329 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
Re: [AI] Excel question
what do you exactly want to do can you give clear detail? Umesha - Original Message - From: Geetha Shamanna gee...@millernorbert.de To: accessindia@accessindia.org.in Sent: Tuesday, December 13, 2011 11:42 PM Subject: [AI] Excel question Hello all, Does Excel offer any keyboard shortcuts for highlighting sections of text in particular cells in a specific colour? Or should one use the Format/Font/Colour option each time to change the colour? Many thanks. Geetha 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 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
Re: [AI] Excel question
Excel 2003. -Original Message- From: accessindia-boun...@accessindia.org.in [mailto:accessindia-boun...@accessindia.org.in] On Behalf Of Jayant Mahajan Sent: 14 December 2011 05:27 To: accessindia@accessindia.org.in Subject: Re: [AI] Excel question Which Version of Xcel r u using? is it 2007 ? On Tue, Dec 13, 2011 at 11:42 PM, Geetha Shamanna gee...@millernorbert.dewrote: Hello all, Does Excel offer any keyboard shortcuts for highlighting sections of text in particular cells in a specific colour? Or should one use the Format/Font/Colour option each time to change the colour? Many thanks. Geetha 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 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 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
[AI] Excel question
Hello all, Does Excel offer any keyboard shortcuts for highlighting sections of text in particular cells in a specific colour? Or should one use the Format/Font/Colour option each time to change the colour? Many thanks. Geetha 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
Re: [AI] Excel question
Hello Geetha, If you are looking at highlighting specific cells in a worksheet based on the results or the cell contents, you might want to consider conditional formatting which is a powerful feature of Excel. If not you will have to select the cells and Control 1 to bring up the editing dialog box and do it the way you mentioned. More on conditional formatting explained at: http://www.techrepublic.com/blog/msoffice/create-your-own-conditional-formatting-rules-in-excel-2007/814 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
Re: [AI] Excel question
On 12/13/11, Geetha Shamanna gee...@millernorbert.de wrote: Hello all, Does Excel offer any keyboard shortcuts for highlighting sections of text in particular cells in a specific colour? Or should one use the Format/Font/Colour option each time to change the colour? Many thanks. Geetha 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 Dear geetha, To format a particular cell you can use ctrl + alpha numeric 1 key to activate format cell box and you can choose font color and borders for the cell and if you want to keep same format which you have previousely used then go to the cell of which you want to use the format then press ctrl + c to copy then go to the cell where you want to apply then press application key and select paste special and select format and you will notice that the same cell format has been copied. For any assistance mail me at zos...@gmail.com or skype me and the ID is zoher.kheriwala 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
Re: [AI] Excel question
Which Version of Xcel r u using? is it 2007 ? On Tue, Dec 13, 2011 at 11:42 PM, Geetha Shamanna gee...@millernorbert.dewrote: Hello all, Does Excel offer any keyboard shortcuts for highlighting sections of text in particular cells in a specific colour? Or should one use the Format/Font/Colour option each time to change the colour? Many thanks. Geetha 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 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
[AI] excel question
Hi friends, I'm required to use the vlookup function in excel at work. Finding corresponding references from different work books and work sheets form an important part of my work. I'm finding difficulties using jaws to work around this function. While in selection, jaws does not announce the row and column titles there by do not enable me to select correct rows. Please provide me with instructions for using vlookup functions with specific jaws key strokes. Regards, Fayaz Fayaz Pasha Mobile 9845942395 MSN ID [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
Re: [AI] Excel question.
On 8/25/06, Kaja, Kiran [EMAIL PROTECTED] wrote: Just curious as to why you would want to store phone numbers in Excel of all programs. There is the Windows and Outlook address book which have better features.If you have a set of good external speakers, you can search for an address book which generates touch tones. Idon't know of anyone. Also, this way, you can only dial from a touch tone capable landline phone. You place the handset near the speakers and start generating the touch tones. There may be applications which may turn your modem into an answering machine. Kiran. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Mamta Chandiramani Sent: Friday, 25 August 2006 2:51 PM To: accessindia@accessindia.org.in Subject: [AI] Excel question. Hello, If I store all my phone numbers in Microsoft Excel, Is there any way by which I can ask my phone or Internal modem to dial it? Or is there any other way by which stored phone number from Excel can be dialed? Your help is appreciated. Many thanks. Regards Mamta. - Here's a new way to find what you're looking for - Yahoo! Answers Send FREE SMS to your friend's mobile from Yahoo! Messenger Version 8. Get it NOW 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.i n 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 Hi Friends, I am also looking out for a similar facility on computer so it facilitates my work. Please do specify what you want to convey in details. Kiran, Also i havent recieved any mail on my earlier request for knowing the facilities and concessions by various agencies. regards Ekinath 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
Re: [AI] Excel question.
Hi Ekinath, 1. Please check and ensure that your replies come at the top of the messages. If they are at the end, not may people will bother to read by going down. 2. This is a group where members provide information and participate voluntarily. There is no guarantee that all your questions will be and have to be answered. If anyone knows an answer to your reply and if they hve enough time to do so, they will reply. Otherwise they will not. By the way, I remember at least one person, I think Bhavani Shankar Varma it is who has already mentioned a couple of times that he has sent you the information as a zip file attachment directly to your e-mail address. HTH, Kiran. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of ekinath ekinath Sent: Monday, August 28, 2006 1:05 PM To: accessindia@accessindia.org.in Subject: Re: [AI] Excel question. On 8/25/06, Kaja, Kiran [EMAIL PROTECTED] wrote: Just curious as to why you would want to store phone numbers in Excel of all programs. There is the Windows and Outlook address book which have better features.If you have a set of good external speakers, you can search for an address book which generates touch tones. Idon't know of anyone. Also, this way, you can only dial from a touch tone capable landline phone. You place the handset near the speakers and start generating the touch tones. There may be applications which may turn your modem into an answering machine. Kiran. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Mamta Chandiramani Sent: Friday, 25 August 2006 2:51 PM To: accessindia@accessindia.org.in Subject: [AI] Excel question. Hello, If I store all my phone numbers in Microsoft Excel, Is there any way by which I can ask my phone or Internal modem to dial it? Or is there any other way by which stored phone number from Excel can be dialed? Your help is appreciated. Many thanks. Regards Mamta. - Here's a new way to find what you're looking for - Yahoo! Answers Send FREE SMS to your friend's mobile from Yahoo! Messenger Version 8. Get it NOW 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 .i n 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 Hi Friends, I am also looking out for a similar facility on computer so it facilitates my work. Please do specify what you want to convey in details. Kiran, Also i havent recieved any mail on my earlier request for knowing the facilities and concessions by various agencies. regards Ekinath 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 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
[AI] Excel question.
Hello, If I store all my phone numbers in Microsoft Excel, Is there any way by which I can ask my phone or Internal modem to dial it? Or is there any other way by which stored phone number from Excel can be dialed? Your help is appreciated. Many thanks. Regards Mamta. - Here's a new way to find what you're looking for - Yahoo! Answers Send FREE SMS to your friend's mobile from Yahoo! Messenger Version 8. Get it NOW 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
Re: [AI] Excel question.
Just curious as to why you would want to store phone numbers in Excel of all programs. There is the Windows and Outlook address book which have better features.If you have a set of good external speakers, you can search for an address book which generates touch tones. Idon't know of anyone. Also, this way, you can only dial from a touch tone capable landline phone. You place the handset near the speakers and start generating the touch tones. There may be applications which may turn your modem into an answering machine. Kiran. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Mamta Chandiramani Sent: Friday, 25 August 2006 2:51 PM To: accessindia@accessindia.org.in Subject: [AI] Excel question. Hello, If I store all my phone numbers in Microsoft Excel, Is there any way by which I can ask my phone or Internal modem to dial it? Or is there any other way by which stored phone number from Excel can be dialed? Your help is appreciated. Many thanks. Regards Mamta. - Here's a new way to find what you're looking for - Yahoo! Answers Send FREE SMS to your friend's mobile from Yahoo! Messenger Version 8. Get it NOW 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.i n 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