Thread: Easiest one-cell formula for multiplying array elements

Hi to everyone and thanks in advance for your support. Here is the question: what is the easiest one cell formula for multiplying all elements in an array ? Say that I have a 3 cells array (A1:A3) containing 2, 3 and 5. I would need a formula whose result is 30.

Thanks

Paolo

Would this work for you?

=PRODUCT(A1:C1)

Hope that helps.