Ask Your Question
0

Multiply one cell by values in list of other cells?

asked 2017-01-23 18:17:43 +0200

RonJohn63 gravatar image

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

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted
1

answered 2017-01-23 18:36:26 +0200

pierre-yves samyn gravatar image

Hi

=PRODUCT(A1;B1:B10)

Note: adapt ; according to your ToolsOptionsCalcFormulaSeparators

Regards

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2017-01-23 18:17:43 +0200

Seen: 51 times

Last updated: Jan 23 '17