multiplicative calcuation

[Jenn]

i have a range of cells A2 through AW:2, and would like to complete a
multiplicative calcuation. Any ideas how to do that other than
A2*B2*C2*D2... etc?

 

[muddan madhu]

=product(A2:AW2)

 

[Tom Hutchins]

Try

=PRODUCT(A2:AW2)

Hope this helps,

Hutch

 

[Bernd P]

Hello,

Just for the fun of it:
array-enter
=EXP(SUM(LN(A2:AW2)))

Regards,
Bernd