Re: $$Excel-Macros$$ Help required on how to create iterative formula
Thank you so much for all your help On Thu, May 3, 2012 at 9:30 AM, David Grugeon da...@grugeon.com.au wrote: If you want to calculate for a different net amount (m) just put the new value in the cell at the top marked Target. All the calcs will then change. You can also change (h) if required but if you change any of the other formulas the whole exercise has to be reworked. On 3 May 2012 13:49, Milin Sulakhi milinsula...@gmail.com wrote: Thanks David. It is working. Though I am still trying to understand algebra :) Just one more query : as data input value will change the formula will also change , right ? Regards, Milin On Thu, May 3, 2012 at 4:54 AM, David Grugeon da...@grugeon.com.auwrote: Hi Milin I attach a revised version with working formulae. You put the target figure in at the top and it calculates everything else. I also attach the workings showing the algebra used to work out the formula to put in the CTC cell. Sorry it is a bit scruffy but it may help you understand how to work this sort of problem out. On 1 May 2012 18:18, Milin Sulakhi milinsula...@gmail.com wrote: Dear David, Thanks for your response. Row 7 - d oth all is always a balancing number arrived on calculation. This is one of the place where it goes in circular reference The label for row 13 (G ESIC) is (a+b+c) x 4.75 % but the formula is b+c+d x 4.75%. Which should it be? - I have changed this label. It was my mistake. Sorry for that. If row 19 is not meant to be zero, please explain how row 7 is meant to be calculated? Perhaps the value of row 19 should be provided? this is check build in. It should always be zero. If not , then there is some error in calculation Perhaps you could put in column H the results that you expect to get in column F - i have added output expected under both scenarios in revised file (attached) I have also mentioned how did i arrive at those results. Kindly help me with this.. Regards, Milin On Tue, May 1, 2012 at 10:59 AM, David Grugeon da...@grugeon.com.auwrote: In your spreadsheet d will always be a - all the other deductions therefore row 19 will always be zero. Is that what you wanted? If so you could replace all the row 19 formulas with 0 The label for row 13 (G ESIC) is (a+b+c) x 4.75 % but the formula is b+c+d x 4.75%. Which should it be? If row 19 is not meant to be zero, please explain how row 7 is meant to be calculated? Perhaps the value of row 19 should be provided? It is not impossible but you need to rewrite the formulas so that iteration is not needed, otherwise you will get meaningless results. Perhaps you could put in column H the results that you expect to get in column F. On 1 May 2012 14:47, Milin Sulakhi milinsula...@gmail.com wrote: Dear All, Please at least let me know if it is not possible... Regards, Milin -- David Grugeon -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- David Grugeon -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member.
Re: $$Excel-Macros$$ Help required on how to create iterative formula
If you want to calculate for a different net amount (m) just put the new value in the cell at the top marked Target. All the calcs will then change. You can also change (h) if required but if you change any of the other formulas the whole exercise has to be reworked. On 3 May 2012 13:49, Milin Sulakhi milinsula...@gmail.com wrote: Thanks David. It is working. Though I am still trying to understand algebra :) Just one more query : as data input value will change the formula will also change , right ? Regards, Milin On Thu, May 3, 2012 at 4:54 AM, David Grugeon da...@grugeon.com.auwrote: Hi Milin I attach a revised version with working formulae. You put the target figure in at the top and it calculates everything else. I also attach the workings showing the algebra used to work out the formula to put in the CTC cell. Sorry it is a bit scruffy but it may help you understand how to work this sort of problem out. On 1 May 2012 18:18, Milin Sulakhi milinsula...@gmail.com wrote: Dear David, Thanks for your response. Row 7 - d oth all is always a balancing number arrived on calculation. This is one of the place where it goes in circular reference The label for row 13 (G ESIC) is (a+b+c) x 4.75 % but the formula is b+c+d x 4.75%. Which should it be? - I have changed this label. It was my mistake. Sorry for that. If row 19 is not meant to be zero, please explain how row 7 is meant to be calculated? Perhaps the value of row 19 should be provided? this is check build in. It should always be zero. If not , then there is some error in calculation Perhaps you could put in column H the results that you expect to get in column F - i have added output expected under both scenarios in revised file (attached) I have also mentioned how did i arrive at those results. Kindly help me with this.. Regards, Milin On Tue, May 1, 2012 at 10:59 AM, David Grugeon da...@grugeon.com.auwrote: In your spreadsheet d will always be a - all the other deductions therefore row 19 will always be zero. Is that what you wanted? If so you could replace all the row 19 formulas with 0 The label for row 13 (G ESIC) is (a+b+c) x 4.75 % but the formula is b+c+d x 4.75%. Which should it be? If row 19 is not meant to be zero, please explain how row 7 is meant to be calculated? Perhaps the value of row 19 should be provided? It is not impossible but you need to rewrite the formulas so that iteration is not needed, otherwise you will get meaningless results. Perhaps you could put in column H the results that you expect to get in column F. On 1 May 2012 14:47, Milin Sulakhi milinsula...@gmail.com wrote: Dear All, Please at least let me know if it is not possible... Regards, Milin -- David Grugeon -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- David Grugeon -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive,
Re: $$Excel-Macros$$ Help required on how to create iterative formula
Dear David, Thanks for your response. Row 7 - d oth all is always a balancing number arrived on calculation. This is one of the place where it goes in circular reference The label for row 13 (G ESIC) is (a+b+c) x 4.75 % but the formula is b+c+d x 4.75%. Which should it be? - I have changed this label. It was my mistake. Sorry for that. If row 19 is not meant to be zero, please explain how row 7 is meant to be calculated? Perhaps the value of row 19 should be provided? this is check build in. It should always be zero. If not , then there is some error in calculation Perhaps you could put in column H the results that you expect to get in column F - i have added output expected under both scenarios in revised file (attached) I have also mentioned how did i arrive at those results. Kindly help me with this.. Regards, Milin On Tue, May 1, 2012 at 10:59 AM, David Grugeon da...@grugeon.com.au wrote: In your spreadsheet d will always be a - all the other deductions therefore row 19 will always be zero. Is that what you wanted? If so you could replace all the row 19 formulas with 0 The label for row 13 (G ESIC) is (a+b+c) x 4.75 % but the formula is b+c+d x 4.75%. Which should it be? If row 19 is not meant to be zero, please explain how row 7 is meant to be calculated? Perhaps the value of row 19 should be provided? It is not impossible but you need to rewrite the formulas so that iteration is not needed, otherwise you will get meaningless results. Perhaps you could put in column H the results that you expect to get in column F. On 1 May 2012 14:47, Milin Sulakhi milinsula...@gmail.com wrote: Dear All, Please at least let me know if it is not possible... Regards, Milin -- David Grugeon -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com iterative formual help.xlsx Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
Re: $$Excel-Macros$$ Help required on how to create iterative formula
Dear All, Please help me with below mentioned query. On Sat, Apr 28, 2012 at 10:05 PM, Milin Sulakhi milinsula...@gmail.comwrote: Dear Rajan, What will be that formula in both scenarios ? Please help me with the same. Regards, Milin On Sat, Apr 28, 2012 at 9:24 PM, Rajan_Verma rajanverma1...@gmail.comwrote: ** ** Formula. ** ** *From:* excel-macros@googlegroups.com [mailto: excel-macros@googlegroups.com] *On Behalf Of *Milin Sulakhi *Sent:* Apr/Sat/2012 08:47 *To:* excel-macros@googlegroups.com *Subject:* Re: $$Excel-Macros$$ Help required on how to create iterative formula ** ** Dear Rajan, ** ** But I will need to add formula or values in cells marked Green in attached file. Right ? ** ** Regards, ** ** Milin On Sat, Apr 28, 2012 at 7:32 PM, Rajan_Verma rajanverma1...@gmail.com wrote: Set the Maximum Iteration to 1 then Calculate formula by F2 and Enter Rajan. *From:* excel-macros@googlegroups.com [mailto: excel-macros@googlegroups.com] *On Behalf Of *Milin Sulakhi *Sent:* Apr/Sat/2012 06:42 *To:* excel-macros@googlegroups.com; milinsula...@gmail.com *Subject:* $$Excel-Macros$$ Help required on how to create iterative formula Dear Excel Gurus, I need help on calculating some iterative formula where result is the basis of some calculation within formula. I have activated iterative calculations under excel options. There are 2 scenarios I need to create. Please help me with excel formulas without using Goalseek , as I need to do this for many times. Regards, Milin Sulakhi -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com ** ** -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members
Re: $$Excel-Macros$$ Help required on how to create iterative formula
Dear All, Please at least let me know if it is not possible... Regards, Milin On Mon, Apr 30, 2012 at 12:01 PM, Milin Sulakhi milinsula...@gmail.comwrote: Dear All, Please help me with below mentioned query. On Sat, Apr 28, 2012 at 10:05 PM, Milin Sulakhi milinsula...@gmail.comwrote: Dear Rajan, What will be that formula in both scenarios ? Please help me with the same. Regards, Milin On Sat, Apr 28, 2012 at 9:24 PM, Rajan_Verma rajanverma1...@gmail.comwrote: ** ** Formula. ** ** *From:* excel-macros@googlegroups.com [mailto: excel-macros@googlegroups.com] *On Behalf Of *Milin Sulakhi *Sent:* Apr/Sat/2012 08:47 *To:* excel-macros@googlegroups.com *Subject:* Re: $$Excel-Macros$$ Help required on how to create iterative formula ** ** Dear Rajan, ** ** But I will need to add formula or values in cells marked Green in attached file. Right ? ** ** Regards, ** ** Milin On Sat, Apr 28, 2012 at 7:32 PM, Rajan_Verma rajanverma1...@gmail.com wrote: Set the Maximum Iteration to 1 then Calculate formula by F2 and Enter*** * Rajan. *From:* excel-macros@googlegroups.com [mailto: excel-macros@googlegroups.com] *On Behalf Of *Milin Sulakhi *Sent:* Apr/Sat/2012 06:42 *To:* excel-macros@googlegroups.com; milinsula...@gmail.com *Subject:* $$Excel-Macros$$ Help required on how to create iterative formula Dear Excel Gurus, I need help on calculating some iterative formula where result is the basis of some calculation within formula. I have activated iterative calculations under excel options. There are 2 scenarios I need to create. Please help me with excel formulas without using Goalseek , as I need to do this for many times. Regards, Milin Sulakhi -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com ** ** -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links
Re: $$Excel-Macros$$ Help required on how to create iterative formula
In your spreadsheet d will always be a - all the other deductions therefore row 19 will always be zero. Is that what you wanted? If so you could replace all the row 19 formulas with 0 The label for row 13 (G ESIC) is (a+b+c) x 4.75 % but the formula is b+c+d x 4.75%. Which should it be? If row 19 is not meant to be zero, please explain how row 7 is meant to be calculated? Perhaps the value of row 19 should be provided? It is not impossible but you need to rewrite the formulas so that iteration is not needed, otherwise you will get meaningless results. Perhaps you could put in column H the results that you expect to get in column F. On 1 May 2012 14:47, Milin Sulakhi milinsula...@gmail.com wrote: Dear All, Please at least let me know if it is not possible... Regards, Milin -- David Grugeon -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
$$Excel-Macros$$ Help required on how to create iterative formula
Dear Excel Gurus, I need help on calculating some iterative formula where result is the basis of some calculation within formula. I have activated iterative calculations under excel options. There are 2 scenarios I need to create. Please help me with excel formulas without using Goalseek , as I need to do this for many times. Regards, Milin Sulakhi -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com iterative formual help.xlsx Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
RE: $$Excel-Macros$$ Help required on how to create iterative formula
Set the Maximum Iteration to 1 then Calculate formula by F2 and Enter Rajan. From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Milin Sulakhi Sent: Apr/Sat/2012 06:42 To: excel-macros@googlegroups.com; milinsula...@gmail.com Subject: $$Excel-Macros$$ Help required on how to create iterative formula Dear Excel Gurus, I need help on calculating some iterative formula where result is the basis of some calculation within formula. I have activated iterative calculations under excel options. There are 2 scenarios I need to create. Please help me with excel formulas without using Goalseek , as I need to do this for many times. Regards, Milin Sulakhi -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
Re: $$Excel-Macros$$ Help required on how to create iterative formula
Dear Rajan, But I will need to add formula or values in cells marked Green in attached file. Right ? Regards, Milin On Sat, Apr 28, 2012 at 7:32 PM, Rajan_Verma rajanverma1...@gmail.comwrote: Set the Maximum Iteration to 1 then Calculate formula by F2 and Enter ** ** Rajan. ** ** *From:* excel-macros@googlegroups.com [mailto: excel-macros@googlegroups.com] *On Behalf Of *Milin Sulakhi *Sent:* Apr/Sat/2012 06:42 *To:* excel-macros@googlegroups.com; milinsula...@gmail.com *Subject:* $$Excel-Macros$$ Help required on how to create iterative formula ** ** Dear Excel Gurus, ** ** I need help on calculating some iterative formula where result is the basis of some calculation within formula. ** ** I have activated iterative calculations under excel options. ** ** There are 2 scenarios I need to create. ** ** Please help me with excel formulas without using Goalseek , as I need to do this for many times. ** ** Regards, ** ** Milin Sulakhi -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com iterative formual help.xlsx Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
RE: $$Excel-Macros$$ Help required on how to create iterative formula
Formula. From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Milin Sulakhi Sent: Apr/Sat/2012 08:47 To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Help required on how to create iterative formula Dear Rajan, But I will need to add formula or values in cells marked Green in attached file. Right ? Regards, Milin On Sat, Apr 28, 2012 at 7:32 PM, Rajan_Verma rajanverma1...@gmail.com wrote: Set the Maximum Iteration to 1 then Calculate formula by F2 and Enter Rajan. From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Milin Sulakhi Sent: Apr/Sat/2012 06:42 To: excel-macros@googlegroups.com; milinsula...@gmail.com Subject: $$Excel-Macros$$ Help required on how to create iterative formula Dear Excel Gurus, I need help on calculating some iterative formula where result is the basis of some calculation within formula. I have activated iterative calculations under excel options. There are 2 scenarios I need to create. Please help me with excel formulas without using Goalseek , as I need to do this for many times. Regards, Milin Sulakhi -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
Re: $$Excel-Macros$$ Help required on how to create iterative formula
Dear Rajan, What will be that formula in both scenarios ? Please help me with the same. Regards, Milin On Sat, Apr 28, 2012 at 9:24 PM, Rajan_Verma rajanverma1...@gmail.comwrote: ** ** Formula. ** ** *From:* excel-macros@googlegroups.com [mailto: excel-macros@googlegroups.com] *On Behalf Of *Milin Sulakhi *Sent:* Apr/Sat/2012 08:47 *To:* excel-macros@googlegroups.com *Subject:* Re: $$Excel-Macros$$ Help required on how to create iterative formula ** ** Dear Rajan, ** ** But I will need to add formula or values in cells marked Green in attached file. Right ? ** ** Regards, ** ** Milin On Sat, Apr 28, 2012 at 7:32 PM, Rajan_Verma rajanverma1...@gmail.com wrote: Set the Maximum Iteration to 1 then Calculate formula by F2 and Enter Rajan. *From:* excel-macros@googlegroups.com [mailto: excel-macros@googlegroups.com] *On Behalf Of *Milin Sulakhi *Sent:* Apr/Sat/2012 06:42 *To:* excel-macros@googlegroups.com; milinsula...@gmail.com *Subject:* $$Excel-Macros$$ Help required on how to create iterative formula Dear Excel Gurus, I need help on calculating some iterative formula where result is the basis of some calculation within formula. I have activated iterative calculations under excel options. There are 2 scenarios I need to create. Please help me with excel formulas without using Goalseek , as I need to do this for many times. Regards, Milin Sulakhi -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com ** ** -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss