Say for e.g that in col A you have a value and in col B you have another
value. Now if you want multiply the values of col A with col B and the result
you want in col C then the simplest formula is
=A1*B1
you will get the result in C or in any cell that you select.