How to Multiply in Google Sheets | Scribe

    How to Multiply in Google Sheets

    • 23 steps |
    • 2 minutes
    • Google SheetsGoogle Sheets

    How to Multiple Numbers Directly in Google Sheets

    1
    Navigate to [https://docs.google.com/spreadsheets/](https://docs.google.com/spreadsheets/d/11yQjHlR4yOj2gag5r98eh2RO4n2HyQOptMRENdhhltU/edit?gid=1564491323#gid=1564491323)
    2
    Click the cell where you wish the result to appear.
    3
    Type the multiplication formula with numbers. You should first type in the [[=]] symbol and then the multiplication. In this example, I entered [[=3\*5]]
    4
    Press [[enter]]
    5
    The multiplication result will automatically appear in the cell.

    How to Multiple Numbers Using Cell References in Google Sheets

    6
    Navigate to [https://docs.google.com/spreadsheets/](https://docs.google.com/spreadsheets/d/11yQjHlR4yOj2gag5r98eh2RO4n2HyQOptMRENdhhltU/edit?gid=1564491323#gid=1564491323)
    7
    Enter the numbers you want to multiply in separate cells. In this example, I entered 3 in A1 and 5 in B1.
    8
    Click on the cell where you want the result to appear.
    9
    Type [[=]] followed by the cell references and the multiplication symbol. In this case, the function looks like this [[=A1\*B1]]
    10
    Press [[enter]]
    11
    The multiplication result will automatically appear in the cell you had selected.
    information ordinal icon
    Tip! This is an ideal method for scenarios where your data might change, as the formula will automatically update the result.

    How to Use the Multiply Formula in Google Sheets

    information ordinal icon
    Tip! Google Sheets offers a specific formula for multiplying two numbers, known as the 'MULTIPLY' formula. The 'MULTIPLY' formula in Google Sheets is designed to multiply two numbers. Its syntax is [[=MULTIPLY(number1, number2)]]
    12
    Navigate to [https://docs.google.com/spreadsheets/](https://docs.google.com/spreadsheets/d/11yQjHlR4yOj2gag5r98eh2RO4n2HyQOptMRENdhhltU/edit?gid=1564491323#gid=1564491323)
    13
    Enter the numbers you want to multiply in separate cells. In this example, I entered 3 in A1 and 5 in B1.
    14
    Click on the cell where you want the multiplication result to appear.
    15
    Type [[=MULTIPLY(A1, B1)]] (or whatever cells you want to multiply)