I simply want to multiply column
h with column
j, and store the result in column
k in each row.
What do I type in as the formula to do this?
Add the following formula in
=ARRAYFORMULA(H:H * J:J)
If you have a header in the first row, then do this:
=ARRAYFORMULA(H2:H * J2:J)
To avoid the remaining zero's, best is to select a fixed range:
=ARRAYFORMULA(H2:H250 * J2:J250)