As Seen on TechCrunch: Finofo Raises $1.65M CAD!

Excel Guide

How to Multiply on Excel: A Step-by-Step Guide

If you're looking to multiply in Excel, you've come to the right place. In this guide, we'll walk you through step by step on how to multiply in Excel, covering different methods and providing some useful tips and tricks along the way.

Opening Excel

On Mac:

  • Find Excel in the Applications folder.

On PC:

  • Find Excel under the Start menu.

Creating a New Workbook

  1. Go to the File menu.
  2. Select New to create a new workbook.

Entering Data

  1. Click on a cell in the workbook.
  2. Start typing to enter data (text, numbers, dates, etc.).

Multiplying in Excel

The * Operator

  1. Type the asterisk (*) between two numbers to multiply them.
  2. Example: 2*3 multiplies 2 by 3.

The PRODUCT Function

  1. Use the PRODUCT function for multiplying two or more numbers.
  2. Example: PRODUCT(2,3) multiplies 2 by 3, returning the answer 6.

The * Operator (Array Form)

  1. Multiply an entire column or row of numbers.
  2. Select the entire column or row.
  3. Type the asterisk (*) followed by the desired multiplier.
  4. Example: Multiply all numbers in column A by 3: 3*.

Tips and Tricks

Rounding Numbers

  1. Use the ROUND function to round numbers.
  2. Example: ROUND(2.345,2) rounds 2.345 to 2.35.

Formatting Numbers

  1. Select cells to format.
  2. Go to the Format menu to find various formatting options.

Multiplying by a Percentage

  1. Multiply by a percentage using the PERCENT function.
  2. Example: PERCENT(100,10) calculates 10% of 100, returning the answer 10.


You've learned various methods to multiply in Excel along with some tips and tricks. If you have any questions, feel free to leave a comment below. Happy calculating!