ExcelBanter - multiplicative calcuation

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - multiplicative calcuation (https://www.excelbanter.com/excel-discussion-misc-queries/206779-multiplicative-calcuation.html)

jenn

multiplicative calcuation

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

multiplicative calcuation

=product(A2:AW2)

On Oct 17, 9:43*pm, Jenn wrote:
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?

Tom Hutchins

multiplicative calcuation

Try

=PRODUCT(A2:AW2)

Hope this helps,

Hutch

"Jenn" wrote:

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?

Bernd P

multiplicative calcuation

Hello,

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

Regards,
Bernd

All times are GMT +1. The time now is 02:54 AM.