lezawang
Well-known Member
- Joined
- Mar 27, 2016
- Messages
- 1,805
- Office Version
- 2016
- Platform
- Windows
Hi
What is the best way to do multiplication. Lets say I want to multiple all the cells in range A1:A10
=A1*A2*A3*A4..... *A10
and let say I want to multipley A1:A10 * B1:B4
=A1*A2*A3.... *A10 *B1*B2*...*B4
Writing a formula to do multiplication is ok if I have few numbers but let say I have 100 or 1000 etc. I thought it must be better way to do that. Thank you so much.
What is the best way to do multiplication. Lets say I want to multiple all the cells in range A1:A10
=A1*A2*A3*A4..... *A10
and let say I want to multipley A1:A10 * B1:B4
=A1*A2*A3.... *A10 *B1*B2*...*B4
Writing a formula to do multiplication is ok if I have few numbers but let say I have 100 or 1000 etc. I thought it must be better way to do that. Thank you so much.