Home 
Search 
Today's Posts 
#1




Changing function name in formula
I'm trying to create a formula that will allow changing the
function used. For example: A B 1 2 Product 2 3 3 4 =B1(A1:A2) =B1(A1:A2) should evaluate to 6. How can I get B1 to not be evaluated as text ?  Ronald K. 
#2




Changing function name in formula
Hi Ronald,
Place the cursor in B1 cell and press Alt+E+A+F and copy and the paste or type the below formula B1 cell =Sum(A1:A2) Or =A1+A2 The above formula will evaluate the result as 5. Hope that helps!  Sixthsense On Jul 20, 3:45*am, kittronald wrote: * *I'm trying to create a formula that will allow changing the function used. * *For example: * * * * A * * * B 1 * * * 2 * * * Product 2 * * * 3 3 4 * * * =B1(A1:A2) * *=B1(A1:A2) should evaluate to 6. * *How can I get B1 to not be evaluated as text ?  Ronald K. 
#3




Changing function name in formula
I think the OP wanted the product, not the sum.
=PRODUCT(A1:A2) or =A1*A2 will give the product. David Biddulph On 20/07/2011 08:04, Sixthsense wrote: Hi Ronald, Place the cursor in B1 cell and press Alt+E+A+F and copy and the paste or type the below formula B1 cell =Sum(A1:A2) Or =A1+A2 The above formula will evaluate the result as 5. Hope that helps!  Sixthsense On Jul 20, 3:45 am, wrote: I'm trying to create a formula that will allow changing the function used. For example: A B 1 2 Product 2 3 3 4 =B1(A1:A2) =B1(A1:A2) should evaluate to 6. How can I get B1 to not be evaluated as text ?  Ronald K. 
#4




Changing function name in formula
hi,
=EvaluateString(B1&"(A1:A2)") Function EvaluateString(tString As String) EvaluateString = Evaluate(tString) End Function cell B1 can contain a function like Product, Sum, Max, Min, etc..  isabelle 
#5




Changing function name in formula
Isabelle,
Thanks for the response and understanding what I was trying to accomplish. For calculating one cell, your solution works. Is there a way to modify it so that I can Fill Down or Fill Right. For example, if I were to fill right ... =EvaluateString($B$1&"(A1:A2)") it should look like ... =EvaluateString($B$1&"(B1:B2)").  Ronald K. 
#6




Changing function name in formula
Isabelle,
Figured it out. =EvaluateString($B$1)(A1:A2) You're The Man ... I mean you're The Woman. Thanks for the help.  Ronald K. 
#7




Changing function name in formula
You have tested this thoroughly?
Gord Dibben Microsoft Excel MVP On Wed, 20 Jul 2011 15:49:26 0700 (PDT), kittronald wrote: Isabelle, Figured it out. =EvaluateString($B$1)(A1:A2) You're The Man ... I mean you're The Woman. Thanks for the help.  Ronald K. 
#8




Changing function name in formula
wow, i can confirm that neni ;)
 isabelle Le 20110720 19:04, Gord a écrit : You have tested this thoroughly? 
#9




Changing function name in formula
hi kittronald,
=EvaluateString($B$1&"(B1:B2)"). the cell "B1" can not be do "function name" and be a part of the evaluation  isabelle 
#10




Changing function name in formula
Isabelle,
<Sound of air leaving balloon Ok, so I'm back to square one. I was using a different, third party function, that when evaluated, mysteriously returned a number  which led me to believe the correct value was being returned. Basically, I'm trying to mass replace a function without resorting to using a macro that performs a Search and Replace. If B1 were the linked cell of a ComboBox that had multiple function names, how could I achieve the initial solution ? And how did I earn the title of a Hungarian aunt ?  Ronald K. 
Reply 

Thread Tools  Search this Thread 
Display Modes  


Similar Threads  
Thread  Forum  
Changing the range for averages with out changing the formula.  Excel Worksheet Functions  
Worksheet Function Keeps Changing, need help  Excel Worksheet Functions  
NOW() function that is unchanging  Excel Discussion (Misc queries)  
Changing other fields using IF Function!?  Excel Worksheet Functions  
Can I use TODAY Function in formula without it changing the next .  Excel Discussion (Misc queries) 