How To Multiply In Google Sheets (Using The 3 Basic Methods)

How To Multiply In Google Sheets

Google sheets is a spreadsheet software among Google drive services. One of the interesting features about the software is that it allows users to collaborate, and its spreadsheet format is also compatible with Microsoft Excel which is one of the most used spreadsheet software. While working on spreadsheets, you would a lot of times need to make some calculations like multiplication of values, and if you don’t know what to do exactly, your work would take a longer time than necessary. Multiplying in Microsoft Excel is quite straightforward compared to Google sheets, for Google sheets, there are a couple of ways to multiply. Let’s explore them.

How To Multiply In Google Sheets

Multiply Operator

The multiply operator is simply an asterisk in which you input the values which you want to multiply or the cells which contain the values you want to multiply. You can use the multiply operator to multiply two or more numbers or cells. For example, if the numbers which you want to multiply are 6 and 4, simply go to the empty cell which you want to use for the result and enter (=6*4), and it would be replaced with the answer which is 24. If you’re going to use several signs like addition into multiplication, For example (6×4+6). First, make sure everything comes in the correct order, that is (6*4+6), NOT (6+4*6) because the result would be 60 instead of 30. Instead of using the values in the cell, you can use the cell numbers, for example, if the value 6 is in cell A1, and the value 4 is in cell B1, you can simply enter (A1*B1) and you would get your result which is 24.

SEE ALSO >>> Famous Facebook Avatar Apps: 7 Best Avatar Apps Everyone Is Using 2020

Multiply Formula

While you can use the multiply operator for more than two values, the multiply formula is for some quick multiplication of two cells or values only. For example, Cell A1 has the value 6 and Cell B1 has the value 4. Let’s assume you want your result to be in Cell C1, simply enter [=MULTIPLY(A1,B1)] into cell C1. Or enter [=MULTIPLY(6,4)] into cell C1. In either case, you would have 24 appear as your result.


The array formula is the fastest way to achieve your multiplication in google sheets, especially when dealing with a wide range. You can use it to multiply two or more columns and get the values in split seconds. If you want to multiply 2 columns, for example ranging from A1 to A20, and B1 to B20. If you want your results to appear in C1 to C20, simply enter the formula into cell C1, [=ARRAYFORMULA(A1:A20*B1:B20)]. When you set this array, all the cells stated in the range would automatically multiply accordingly, and the results would appear. You can also set it for as many columns and rows you choose.

RECOMMENDED >>> How To Chargeback On PayPal