Re: $$Excel-Macros$$ GOAL SEEK

2017-06-08 Thread GENIUS
Sir, You are superb,thank you very very very much. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thre

Re: $$Excel-Macros$$ GOAL SEEK

2017-06-08 Thread Sandeep Kumar Baranwal
Hi Use SOLVER. In this case, the Subject to the Constraints : $N$2:$N$21=$O$2:$O$21 Set Objective : $N$2 To : Value of 7 By Changing Variable Cells : $F$2:$F$21 Subject to the Constraints: $N$2:$N$21=$O$2:$O$21 (Uncheck) Make Unconstrained Variables Non-Negative Select a Solving Method :

Re: $$Excel-Macros$$ GOAL SEEK

2017-06-07 Thread GENIUS
Sir, Please one more favor -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please

Re: $$Excel-Macros$$ GOAL SEEK

2017-06-06 Thread GENIUS
OH THAT'S REALLY GREAT, WHAT A ANSWER THANK YOU VERY MUCH SIR regarding solver I have another one could you please look at it. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com

Re: $$Excel-Macros$$ GOAL SEEK

2017-06-05 Thread Sandeep Kumar Baranwal
Hi I tried using SOLVER and it is working. In this case, the Subject to the Constraints : $I$2:$I$15 = $A$2:$A$15 Set Objective : $I$2 To : Value of 15000 By Changing Variable Cells : $E$2:$E$15 Subject to the Constraints: $I$2:$I$15 = $A$2:$A$15 Check (Tick Mark) - Make Unconstrained Varia

Re: $$Excel-Macros$$ GOAL SEEK

2017-06-05 Thread Sandeep Kumar Baranwal
Hi I tried using SOLVER. It is working. But the issue is that constraint need to be mapped manually. In SOLVER: Set Objective : $I$2 To : Value of 15000 By Changing Variable Cells : $E$2:$E$15 Subject to the Constraints: $I$2 = $A$2 $I$3 = $A$3 $I$4 = $A$4 $I$5 = $A$5 $I$6 = $A$6 $I$7 = $A$7

Re: $$Excel-Macros$$ GOAL SEEK

2017-06-05 Thread GENIUS
Thanks Mr Sandeep Kumar Baranwal, I know this but I need the formula ok if there is no formula then can we do it thru SOLVER, if there is any possibility then can you do it, thanks in advance. I'm sure we can do thru SOLVER by applying different parameters *but the problem is what are those pa

Re: $$Excel-Macros$$ GOAL SEEK

2017-06-05 Thread Sandeep Kumar Baranwal
Hi For the purpose of goal seek, we can apply formula. But this formula would work only on a particular cell. For Using Goal Seek formula, go on DATA/What-If Analysis/Goal Seek Goal Seek Inbox would be prompted Set Cell : I2 To value : A2 By Changing Cell : E2 Do it for repeatedly for all , as

RE: $$Excel-Macros$$ Goal Seek option from Tools menu....(little urgent)

2012-03-13 Thread Mohammed Muneer
U r Welcome! Regards, Muneer, CC.. From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Ferry H Sitohang Sent: Tuesday, March 13, 2012 3:27 PM To: excel-macros@googlegroups.com Subject: RE: $$Excel-Macros$$ Goal Seek

Re: $$Excel-Macros$$ Goal Seek option from Tools menu....(little urgent)

2012-03-12 Thread Abhishek Jain
May be this can help - http://www.vbaexpress.com/kb/getarticle.php?kb_id=433 On Mon, Mar 12, 2012 at 1:42 PM, Mohammed Muneer wrote: > Dear Group, I want to select multiple cell values(a1 & b1) to change the > target cell “C1”. > > ** ** > > Can I do it like this? Plz suggest? > > **

RE: $$Excel-Macros$$ Goal seek in macros

2011-06-04 Thread Rajan_Verma
See if it help Worksheets("Sheet1").Range("Polynomial").GoalSeek _ Goal:=15, _ ChangingCell:=Worksheets("Sheet1").Range("X") -Original Message- From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Ritesh Jain Sent: Saturday, June