![]() In case these values are in cell A1 and A2, you can use the below formula: = A1 * A2 Suppose you want to multiply two numbers (12 and 14), you can use the below formula: = 12 * 14 You can also use the multiply operator (an asterisk sign) to quickly multiply two or more cells/numbers in Google Sheets. ![]() Also, you can multiply two formula results or named ranges that refer to a cell Using the MULTIPLY Operator The MULTIPLY formula can only work with two arguments, but if you have more than two, then this formula will give you an error. While I have hard-coded the numbers in the formula in the above example, you can also use the reference to cells that have these values.įor example, if cell A1 has 12 and A2 has 14, you can use the below formula to get the result: = MULTIPLY ( A1, A2 ) This MULTIPLY formula is great to use when you only have two numbers and you want to quickly get the resulting value. Suppose you want to multiply two numbers (12 and 14), you can use the below formula: = MULTIPLY ( 12, 14 ) Since multiplying numbers is such a common task, Google Sheets decided to have a dedicated MULTIPLY formula in it (it’s not there is MS Excel, in case you’re wondering). If you have two numbers or two cells that have the numbers that you want to multiply, there are a couple of techniques to do this. ![]() Multiplying Two Columns In Google Sheets.Multiplying Two Numbers in Google Sheets.
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |