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.

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 <kittron...@yahoo.com> 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.

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, kittronald<kittron...@yahoo.com> 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.
>

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

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.

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.

You have tested this thoroughly?


Gord Dibben Microsoft Excel MVP


On Wed, 20 Jul 2011 15:49:26 -0700 (PDT), kittronald
<(E-Mail Removed)> 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.

wow, i can confirm that neni ;-)


--
isabelle


Le 2011-07-20 19:04, Gord a écrit :
> You have tested this thoroughly?

hi kittronald,

> =EvaluateString($B$1&"(B1:B2)").

the cell "B1" can not be do "function name" and be a part of the evaluation


--
isabelle

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.