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.
|