How to do a multiplication formula in Google Sheets

In today’s tutorial, we will learn to perform multiplication in google sheets. In Google Sheets, multiplication is a mathematical operation that allows you to multiply two or more numbers together within a cell or range of cells. The overall importance of multiplication formulas in Google Sheets (and in spreadsheets in general) is that they allow you to automate calculations involving large amounts of data quickly and accurately.

Our dataset is comprised of a grocery store bill that includes the names of the products, their corresponding quantities and prices, and the total amount. To calculate the total amount, we need to multiply the quantity by the price of each product. To perform this multiplication operation, we have four different methods at our disposal.

Method 1: Multiply using the Steric key(*)

Step 1 – Select the Cell

• Select the cell where you want to show the result of the multiplication

Step 2 – Type the Formula

• After selecting the cell, type the formula
• =Address of First Cell*Address of Second Cell
• Here it is =B2*C2

Step 3 – Press the Enter key

• After typing the formula, press the Enter key to get the result

Step 4 – Apply on Complete Column

• After getting the result in the first cell, move the cursor to the right bottom of the cell and a plus symbol will appear
• Click on this symbol and drag it to the desired cell of the column to get the required result

Method 2: Multiply using the Product function

Step 1 – Select the Cell

• Select the cell where you want to show the result of the multiplication

Step 2 – Use the Product function

• After selecting the cell, type “=Product( ” to use the product function

Step 3 – Type the Arguments

• After typing the function, type its argument
• First Agument: Address of the first cell to multiply(Here it is B2)
• Second Argument: Address of the second cell to multiply(Here it is C2)

Step 4 –  Press the Enter key

• After typing the formula, press the Enter key to get the result

Step 5 – Apply on Complete Column

• After getting the result in the first cell, move the cursor to the right bottom of the cell and a plus symbol will appear
• Click on this symbol and drag it to the desired cell of the column to get the required result

Method 3: Multiply using the MULTIPLY function

Step 1 – Select the Cell

• Select the cell where you want to show the result of the multiplication

Step 2 – Use the Multiply function

• After selecting the cell, type “=Multiply( ” to use the product function

Step 3 – Type the Arguments

• After typing the function, type its argument
• First Agument: Address of the first cell to multiply(Here it is B2)
• Second Argument: Address of the second cell to multiply(Here it is C2)

Step 4 –  Press the Enter key

• After typing the formula, press the Enter key to get the result

Step 5 – Apply on Complete Column

• After getting the result in the first cell, move the cursor to the right bottom of the cell and a plus symbol will appear
• Click on this symbol and drag it to the desired cell of the column to get the required result

Method 4: Multiply Two Columns

Step 1 – Select the Cell

• Select the cell where you want to show the result of the multiplication

Step 2 – Type the Formula

• After selecting the cell, type the formula
• =Range of First Cells*Range of Second Cells
• Here it is =B2:B9*C2:C9

Step 3 – Press the CTRL+Shift+Enter keys

• After typing the formula, press the CTRL+Shift+Enter keys and the formula will be converted into an Array Formula

Step 4 – Press the Enter key

• After getting the ArrayFormula, press the Enter key to get the result