How to Multiply in Google Sheets (from a PC or the App)

-

|

This Itechguide teaches you how to multiply in Google Sheets. The guide offers steps to multiply in Google Sheets from a PC or the Google Sheets App.

The Itechguide also offers different ways you can multiply in Google Sheets…

You can multiply numbers by typing them directly into the formula. You could also multiply with numbers from different cells. This Itechguide teaches how to do both.
Advertisements


1
How to Multiply in Google Sheets from a PC

How to multiply numbers

This section is divided into two sub-sections…

  1. Multiply numbers directly
  2. Multiply numbers from different cells

How to multiply numbers directly

  • Open Sheets.Google.com from your PC. Then open the Google Sheets document you want to multiply in.
  • Click on the cell you want to add the multiply formula. Then type the equal sign (=) followed by the first number you want to multiply. Next to the number, type asterisks (*) followed by the last number you want to include in the multiplication. Here is the general syntax:
=n1*n2

In the syntax, n1 is the first number while n2 is the second in the multiplication.

  • Here is a real example in Google Sheets. I want to multiply 5 and 20. I will click on the cell I want to add the formula. In this example, cell A2. Then type equal sign (=) followed by 5. Then type asterisks (*) followed by 20. When I finish, to multiply numbers in Google Sheets I click Enter in my keyboard.
How to Multiply in Google Sheets from a PC
  • The result is obviously 100!
How to Multiply in Google Sheets from a PC
  • You can also multiply multiple numbers in Google Sheets. For instance to multiply 2, 4 and 7, type the formula below and press Enter.
=2*4*7 

The difference is just adding an additional asterisks (*) after the second number followed by the third number. Here is the example in Google Sheets.

How to Multiply in Google Sheets from a PC

And the result…

How to multiply numbers from different cells

In the last sub-section, I showed how to multiple two numbers directly. But you may also have numbers you want to multiply in different cells.

Here is how you multiply numbers from different cells…

  • In the Google Sheets, click the cell you want the result of the multiplication. In this example, I have numbers in cells A2, A3 and A4 and I want to multiply the numbers in these cells in cell A6. To do that I click cell A6.
Advertisements


  • Then type equal to sign (=). Once you type equal to sign, click on cell A2. Then type asterisks (*) and click cell A3 and type asterisks (*) again. Finally, click cell A4. When you finish, press enter key on the keyboard. The result of the multiplication will be displayed. See the second image below.

2
How to Multiply in Google Sheets from the App

The steps in the section was done on an Android phone but it also applies to the iPhone App.
  • Open Google Sheets App on your phone. Then open the document you want to multiply in.
How to Multiply in Google Sheets from the App
  • When the document opens, click on the cell you want to multiply in. Beneath the app, a text box will become available. See the highlighted portion of the image below.
How to Multiply in Google Sheets from the App
  • To multiply in Google Sheets App, click on the the text box displayed beneath the app. Then click equal sign (=) followed by the first number you want to multiply. Next, click asterisks (*) sign and enter the next number you want to multiply.
When you click on the text box, the signs [=, ( ), *, etc] you need to create a formula will be displayed beneath the box. To include any of the signs in your formula simply click it.
Advertisements


  • When you finish, click the blue tick beside the formula. The result of the multiplication will be displayed in the cell. See the second image below.
How to Multiply in Google Sheets from the App

You can also multiply in Google Sheets App with numbers in different cells.

  • As an example, to multiple the numbers in cells A16, A17 and A18 in cell A19, click A19. Then, on the text bar displayed beneath the app, click equals sign (=), next click cell A16 and click asterisks (*). After the first asterisks (*) click cell A17 followed by a second asterisks (*). Finally, click cell A18. To compute your multiplication, click the blue tick beside the formula. The result will be displayed in cell A19 – see the second image below…

I hope you found this Itechguide helpful. If you do, kindly click the Yes button below. You could also ask a question or leave a comment using the “Leave a Reply” form below.

For more Google guides visit our Google How To page.

  • Was this post Helpful?
  • YesNo

LEAVE A REPLY

Please enter your comment!
Please enter your name here

FEATURED POSTS

How to Embed YouTube Video on Facebook

How to Embed YouTube Video on Facebook

This Itechguide teaches you how to embed YouTube video on Facebook. There are 2 high-level steps discussed in this guide:
How to Cancel Amazon Music Unlimited

How to Cancel Amazon Music Unlimited (PC or Amazon Apps)

This Itechguide teaches you how to cancel Amazon music unlimited. It offers steps to cancel Amazon music unlimited from a PC, Amazon...
How to Change Default Font in Google Docs

How to Change Default Font in Google Docs

This Itechguide teaches you how to change default font in Google Docs. Here are the high-level steps to change default font in...
How to Print Google Slides with Notes

How to Print Google Slides with Notes

This Itechguide teaches you how to print Google Slides with notes.
How to Add Bullet Points in Google Slides

How to Add Bullet Points in Google Slides (Android or iOS Apps or PC)

This Itechguide teaches you how to add bullet points in Google Slides. The guide offers steps to add bullet points in Google...

ADVERTISEMENTS

TRENDING POSTS

Remote Desktop Connection

Remote Desktop Connection an Internal Error Has Occurred [Fixed]

Introduction I recently received the error message "Remote Desktop Connection an Internal Error Has Occurred". It was strange because...

Find My Samsung: Register and Use Samsung Find my Mobile

Introduction Ever wondered how you could find your Samsung phone if you lost it? Find my Samsung or Samsung...
What is the Difference Between PowerShell and CMD?

Windows Powershell vs CMD: Differences and Similarities

Introduction This short guide compares Windows PowerShell vs CMD (Windows command prompt). I will cover the history and nature...
Spotify No Longer Supports this Version of Microsoft Edge

Spotify No Longer Supports this Version of Microsoft Edge [Fixed]

Introduction When you open Spotify web player on Microsoft Edge, you may receive the error message "Spotify No Longer...
Windows 10 Won't Boot

Windows 10 Won’t Boot With Black Screen? 3 Ways to Fix It

Why Won't Windows 10 Boot Up? If your Windows 10 stops with a black screen, the first question in...

BEST OF ITECHGUIDES

vpn windows server 2016

Routing and Remote Access in Windows Server 2016 (Part 3): Configure VPN

Introduction This is part 3 of a 4-part "Routing and Remote Access" series. This part covers how to configure...
roll back windows 10 update

How to Roll Back Windows 10 Update (3 Methods)

Introduction There could be a number of reasons you may want to roll back windows 10 update. One common...
How to Bold YouTube Comments

How to Bold, Italicize or Strike-through YouTube Comments

Introduction This guide demos how to bold YouTube comments - the demo also includes how to italicize, or strike...
Best fantasy Movies on Netflix

Our 10 Best Fantasy Movies on Netflix

Are you ready to know the best fantasy movies on Netflix? Then dive into the fantasy world with us filled amazing...
PowerShell Foreach-Object: Syntax, Parameters, Examples

PowerShell Foreach-Object: Syntax, Parameters, Examples

Introduction PowerShell Foreach-Object is used to iterate through a collection of items to perform a specified action on each...

ADVERTISEMENTS

RECENT POSTS

How to Embed YouTube Video on Facebook

How to Embed YouTube Video on Facebook

This Itechguide teaches you how to embed YouTube video on Facebook. There are 2 high-level steps discussed in this guide:
How to Cancel Amazon Music Unlimited

How to Cancel Amazon Music Unlimited (PC or Amazon Apps)

This Itechguide teaches you how to cancel Amazon music unlimited. It offers steps to cancel Amazon music unlimited from a PC, Amazon...
How to Add to outline in google docs

How to Add to Outline in Google Docs

This Itechguide teaches you how to add to outline in Google Docs. The guide offers steps to add to outline in Google...
How to Go Frame by Frame in YouTube

How to Go Frame by Frame in YouTube

This Itechguide teaches you how to go frame by frame in YouTube. YouTube does not have an inbuilt tool that allows you...
How to Change Default Font in Google Docs

How to Change Default Font in Google Docs

This Itechguide teaches you how to change default font in Google Docs. Here are the high-level steps to change default font in...

MUST READ

Error Code 0xc004fc07 in Server 2016 - "We Can't activate Windows on the device right now."

How to Fix “We Can’t Activate Windows on this Device right Now”

Introduction When you try to activate Windows Server 2016 with the GUI tool you may receive error code 0xc004fc07...

How to Fix “Your PC Ran into a Problem and Needs to Restart” in...

Introduction "Your PC Ran into a Problem and Needs to Restart" in Windows Server 2016 error may be caused...
this accessory may not be supported

This Accessory May Not be Supported [Fix]

What Does This Accessory May Not be Supported Mean? You may receive "this accessory may bot be supported" error...

Spotify Web Player: Your Definitive Guide

What is Spotify Web Player? Spotify Web Player is a browser-based player that allows you to stream Spotify via...

How to Set Homepage in Microsoft Edge (Edge Settings or Group Policy)

Introduction You can set homepage in Edge (Microsoft Edge) directly from Settings. This method is suitable for individual or...

LATEST DEALS

Exclusive Student Offer_Save 10% on selected Surface devices

By using this website you agree to accept our Privacy Policy and Terms & Conditions