Question

If A1= 30, A2 = 20, I want to multiply these two cells and show output in C6. Which formula should I use? Write in cell C6, =30*20 Write in cell C6, =A1*A2 Write in cell C6, Multiply A1 to A2

Answer 1

The method is simple. If the A1 cell has the value 30 and A2 have the value 20 then you can simply type in the formula in C6 cell as ‘=A1 * A2’.

Then press enter, it will give you an accurate answer with the multiplied value which will be = 20 * 30 = 600.