Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Goal Seek
Hello,
i wish to create a function that runs GoalSeek. if, for example, A1 is where i sould type the function, then B1 would be the value to be set, and C1 would be the cell to change till it equals B1, by changing the value in A1. A1 = GS(Target Value, Cell to be set to Value) = GS('B1','C1') '(ie, can be typed in any cell, referencing any cells) which would produce a value that looks like a typical Goalseek value, 2.639568392784 any help would be greatly appreciated G |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Goal Seek
Goto Google Groups:
http://groups.google.com/grphp?hl=en&tab=wg and enter the following in the Search Groups Box: "goal seek function" group:*Excel -- Gary''s Student - gsnu200773 "lawson" wrote: Hello, i wish to create a function that runs GoalSeek. if, for example, A1 is where i sould type the function, then B1 would be the value to be set, and C1 would be the cell to change till it equals B1, by changing the value in A1. A1 = GS(Target Value, Cell to be set to Value) = GS('B1','C1') '(ie, can be typed in any cell, referencing any cells) which would produce a value that looks like a typical Goalseek value, 2.639568392784 any help would be greatly appreciated G |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Goal Seek
How is this function used?
if i have a formula in c5, that reads '=b9^1.7', and i want to set that cell equal to 44 by changing cell b9, how do i use thie 'backward' function to do that? thanks "Gary''s Student" wrote: Goto Google Groups: http://groups.google.com/grphp?hl=en&tab=wg and enter the following in the Search Groups Box: "goal seek function" group:*Excel -- Gary''s Student - gsnu200773 "lawson" wrote: Hello, i wish to create a function that runs GoalSeek. if, for example, A1 is where i sould type the function, then B1 would be the value to be set, and C1 would be the cell to change till it equals B1, by changing the value in A1. A1 = GS(Target Value, Cell to be set to Value) = GS('B1','C1') '(ie, can be typed in any cell, referencing any cells) which would produce a value that looks like a typical Goalseek value, 2.639568392784 any help would be greatly appreciated G |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Goal Seek
Maybe for this particular problem...
=POWER(44,1/1.7) -- HTH :) Dana DeLouis "lawson" wrote in message ... How is this function used? if i have a formula in c5, that reads '=b9^1.7', and i want to set that cell equal to 44 by changing cell b9, how do i use thie 'backward' function to do that? thanks "Gary''s Student" wrote: Goto Google Groups: http://groups.google.com/grphp?hl=en&tab=wg and enter the following in the Search Groups Box: "goal seek function" group:*Excel -- Gary''s Student - gsnu200773 "lawson" wrote: Hello, i wish to create a function that runs GoalSeek. if, for example, A1 is where i sould type the function, then B1 would be the value to be set, and C1 would be the cell to change till it equals B1, by changing the value in A1. A1 = GS(Target Value, Cell to be set to Value) = GS('B1','C1') '(ie, can be typed in any cell, referencing any cells) which would produce a value that looks like a typical Goalseek value, 2.639568392784 any help would be greatly appreciated G |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Goal Seek
Excel has a help function. I would heartily recommend it.
-- David Biddulph "lawson" wrote in message ... How is this function used? if i have a formula in c5, that reads '=b9^1.7', and i want to set that cell equal to 44 by changing cell b9, how do i use thie 'backward' function to do that? "Gary''s Student" wrote: Goto Google Groups: http://groups.google.com/grphp?hl=en&tab=wg and enter the following in the Search Groups Box: "goal seek function" group:*Excel "lawson" wrote: Hello, i wish to create a function that runs GoalSeek. if, for example, A1 is where i sould type the function, then B1 would be the value to be set, and C1 would be the cell to change till it equals B1, by changing the value in A1. A1 = GS(Target Value, Cell to be set to Value) = GS('B1','C1') '(ie, can be typed in any cell, referencing any cells) which would produce a value that looks like a typical Goalseek value, 2.639568392784 any help would be greatly appreciated G |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Goal Seek
thanks, but the formula in my last question was jsut an example. the real
formula i keep having to goalseek is: =MAX(8*$C29,6,IF(AND($C$16=0,$C$90),1/50,IF($C$15=1,IF($B29<=6,1/25,1/20),IF($B29<=6,3/50,3/40)))*$C$5*$C$4*$C29*$C$6/SQRT(Q$21)*IF($C$90,IF(AND($B29<=11,$C$100),$D$1 0,1)*IF(AND($B29<=11,$C$110),$D$11,1)*IF(AND($B29 <=11,$C$120),$D$12,1)*IF($C$130,$D$13,1),1))*IF( $C$16=1,1.3,1) "Dana DeLouis" wrote: Maybe for this particular problem... =POWER(44,1/1.7) -- HTH :) Dana DeLouis "lawson" wrote in message ... How is this function used? if i have a formula in c5, that reads '=b9^1.7', and i want to set that cell equal to 44 by changing cell b9, how do i use thie 'backward' function to do that? thanks "Gary''s Student" wrote: Goto Google Groups: http://groups.google.com/grphp?hl=en&tab=wg and enter the following in the Search Groups Box: "goal seek function" group:*Excel -- Gary''s Student - gsnu200773 "lawson" wrote: Hello, i wish to create a function that runs GoalSeek. if, for example, A1 is where i sould type the function, then B1 would be the value to be set, and C1 would be the cell to change till it equals B1, by changing the value in A1. A1 = GS(Target Value, Cell to be set to Value) = GS('B1','C1') '(ie, can be typed in any cell, referencing any cells) which would produce a value that looks like a typical Goalseek value, 2.639568392784 any help would be greatly appreciated G |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
Goal Seek
You can't run Goal Seek from a worksheet formula. You could write a macro to
automate it, or even record a macro while you do the particular analysis, and rerun it as needed. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "lawson" wrote in message ... Hello, i wish to create a function that runs GoalSeek. if, for example, A1 is where i sould type the function, then B1 would be the value to be set, and C1 would be the cell to change till it equals B1, by changing the value in A1. A1 = GS(Target Value, Cell to be set to Value) = GS('B1','C1') '(ie, can be typed in any cell, referencing any cells) which would produce a value that looks like a typical Goalseek value, 2.639568392784 any help would be greatly appreciated G |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to use goal seek | Excel Worksheet Functions | |||
goal seek | Excel Discussion (Misc queries) | |||
Goal seek gone | Excel Worksheet Functions | |||
Goal Seek | Excel Worksheet Functions | |||
Goal Seek | Excel Worksheet Functions |