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.