Multiply one cell by values in list of other cells?

RonJohn63 · January 23, 2017, 5:17pm

Hi,

Calc 5.1.6.2

I’ve got a number in cell A1, and a list of numbers in B1:B10. How do I multiply A1 by all the numbers in the list, instead of writing something like “=A1B1B2B3B4B5B6B7B8B9B10”

(This isn’t homework… )

Thanks

PYS · January 23, 2017, 5:36pm

Hi

=PRODUCT(A1;B1:B10)

Note: adapt ; according to your Tools▸Options▸Calc▸Formula▸Separators

Regards

AlexKemp · July 9, 2020, 10:55am