How to Multiply Cells in Excel: A Step-by-Step Guide

Excel Multiplication Guide: Learn basic operators, cell references, PRODUCT function usage, and essential tips for accurate calculations in Microsoft Excel.

1 min readExcel Guide
Contents
  1. Basic Multiplication in Excel
  2. Multiplying Cell References
  3. Using the PRODUCT Function
  4. PRODUCT with Non-Adjacent Cells
  5. Column Multiplication
  6. Percentage Calculations
  7. Dynamic Percentage Calculations
  8. Troubleshooting Common Issues

In this article, we will explore how to perform multiplication operations in Microsoft Excel. Whether you're working with simple calculations or complex data sets, mastering Excel's multiplication capabilities is essential for efficient data analysis and calculations.

Basic Multiplication in Excel

The most straightforward way to multiply in Excel is using the multiplication operator (*). To multiply numbers:

  • Click any empty cell in your spreadsheet
  • Type an equals sign (=)
  • Enter your calculation (e.g., =2*4)
  • Press Enter to see the result
Excel formula =2*4 entered in cell C7, with an arrow pointing to the result of 8.

Multiplying Cell References

Instead of typing actual numbers, you can multiply values stored in different cells:

  • Enter numbers in two separate cells
  • In a third cell, type the formula referencing these cells
  • Press Enter to calculate
Excel formula =A1*B1 multiplying cell references 5 and 4 to return 20 in cell C1.

Using the PRODUCT Function

The PRODUCT function is perfect when you need to multiply multiple numbers or cell ranges. For multiplying multiple numbers at once, use =PRODUCT(number1, [number2], ...). Example: =PRODUCT(A1:A4) multiplies all numbers in range A1 through A4.

Excel PRODUCT function =PRODUCT(A1:A4) multiplying 1, 2, 3 and 4 to return 24 in cell A5.

PRODUCT with Non-Adjacent Cells

You can multiply non-consecutive cells using commas to separate references. Combine scattered values using =PRODUCT(A1,C3,E5).

Excel formula =PRODUCT(A1,C3,E5) multiplying non-adjacent cells 10, 5 and 2 to return 100.

Column Multiplication

To multiply entire columns, use array formulas. Enter =A2:A10*B2:B10 and press Ctrl+Shift+Enter to multiply corresponding rows.

Multiplying Entire Columns: For large datasets, use =ARRAYFORMULA(A1:A3*B1:B3). This automatically updates as you add new data.

Excel array formula =A1:A3*B1:B3 multiplying two columns row by row to return 4, 10 and 18.

Percentage Calculations

Calculate percentages by multiplying by decimals. For 15%, multiply by 0.15 or use the formula =A1*15%.

Basic Percentage Multiplication: Find percentage of a number: =100*15% equals 15.

Excel formula =A1*15% calculating 15 percent of 100 to return 15 in cell B1.

Dynamic Percentage Calculations

Excel formula =A1*B1 multiplying 200 by a 25% cell value to return 50, a dynamic percentage calculation.

Pro Tips

  • Always start formulas with an equals sign (=)
  • Double-check cell references before pressing Enter
  • Use parentheses to control calculation order
  • Format cells appropriately to display results clearly

Troubleshooting Common Issues

  • #VALUE! Error: This typically means you're trying to multiply non-numeric values
  • #REF! Error: This occurs when cell references are invalid
  • #NUM! Error: The calculation result is too large or small for Excel to handle

Remember to save your work regularly and test your formulas with small datasets before applying them to larger ones.

Let’s make AP
work for you.