Here is one simple question in excel.
We have a list of numbers, say 100 of them, in A1 to A100. What simple operation can we do to have them all multiply together, such as A101 = A1*A2*A3*... *A100?
I know we can use sum(A1:A100) to add them together and wonder if there is a similar building function to multiply them together. If not, we have to write a custom function in VBA to do that. what can be most efficient way to write that?