Multiply in Excel




In this tutorial, you will learn about how to multiply in excel. This calculation process can be done manually or by using the excel multiply formula which is PRODUCT.


Why do We Need to Learn About Multiplication in Excel?


In doing numeric data processing on a spreadsheet file, one of the calculations often used is multiplication. This type of calculation is often needed in many work areas. If we often use this software but still haven’t understood multiplication, it will make our data processing not optimal.

One of the examples of this calculation type need at work is when we process daily transaction data. In processing it, usually, there are two important variables which are the amount and money value per piece. To get the total transaction value, then we must multiply the amount and the money value per piece variables. If we put this daily transaction data on a spreadsheet file, then we must understand how to do the calculation operation.

For that, it is better we learn how to multiply in excel if we haven’t understood it. This should be done so your data processing can be much easier and faster to do. If you often process numeric data, then your understanding on this becomes much more important.


What is Multiply in Excel?


Multiply in excel is a numeric data processing in a spreadsheet by adding a number in the number of times needed. Like other calculation operations, there are two main methods to get the result which is manually and using a formula. It is recommended to learn both of them so you can process your numeric data optimally.


How to Multiply Excel Data?


The following will explain about two methods to multiply numbers in excel, manually and using a formula. The multiplication on excel formula is PRODUCT. Usually, the manual method is used when the digits to be multiplied are few. On the other hand, the PRODUCT is used when the digits are many.


Method 1: Manual (* Sign)

  1. Type equal sign ( = ) in the cell where you want to put the result in

    Multiply in Excel - Screenshot of Step 1-1

  2. Input numbers or cell coordinates where the numbers which you want to process are after =. Input star signs ( * ) between the numbers or cell coordinates

    Multiply in Excel - Screenshot of Step 1-2

  3. Press Enter
  4. The process is done!

    Multiply in Excel - Screenshot of Step 1-4



Method 2: PRODUCT

  1. Type equal sign ( = ) in the cell where you want to put the result in

    Multiply in Excel - Screenshot of Step 2-1

  2. Type PRODUCT (can be with large and small letters) and open bracket sign after =

    Multiply in Excel - Screenshot of Step 2-2

  3. Input the numbers or cell coordinates or cell ranges where you put the numbers after the open bracket sign. Input comma signs ( , ) between those numbers or cell coordinates

    Multiply in Excel - Screenshot of Step 2-3

  4. Type close bracket sign after all the inputs have been given

    Multiply in Excel - Screenshot of Step 2-4

  5. Press Enter
  6. The process is done!

    Multiply in Excel - Screenshot of Step 2-6



Exercise


After understanding how to multiply in excel using the two methods, now let’s do an exercise. This is done so you can deepen your understanding of how to multiply in excel.

Download the exercise file and answer all the questions. Download the answer key file when you have answered all the questions. Or probably when you are confused about how to finish one or all the questions!

Link to the exercise file:
Download here

Questions

  1. How much total payment is needed for hot dogs, hamburgers, and french fries? Use the manual method with the sign ( * ) to answer!
  2. How much total payment is needed for tacos and sandwiches? Use the PRODUCT formula to answer it!

Link to the answer key file:
Download here


Additional Note


PRODUCT is actually seldom used because you usually only need to multiply a few numbers. However, at the time you need to do multiplication on many numbers, your understanding of using PRODUCT will be very helpful.



Want to Learn More About Excel?


Get updated excel info from Compute Expert by registering your email. It's free!


Want to Learn More About Excel?


Get updated excel info from Compute Expert by registering your email. It's free!



Follow our tutorial content also on


CONTACT US PRIVACY POLICY TERMS AND CONDITION AFFILIATE DISCLOSURE @Compute Expert