I have a column B, so my data is from B1 to say B500. I want C1 to be B1
C2 to be B1*B2.
C3 to be B1*B2*B3
C4 to be B1*...*B4 ...
C500 to be B1*...*B500
Is there an easier way to do this rather than typing the formula manually? I think I can use the function PRODUCT, but I would still have to type the rest of the references manually. Anyone has a more elegant solution?