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

Active Directory FSMO Roles

Active Directory FSMO Roles Explained

Introduction This article offers a simplified explanation of the 5 Active Directory FSMO (pronounced "FisMO") roles.
concatenate excel

Concatenate in Excel: How to Concatenate Columns and Strings

What is Concatenate in Excel? Concatenate in Excel is joining two strings into one continuous string. You can join...
Steps to Fix "Windows has Detected an IP Address Conflict"

How to Fix “Windows has Detected an IP Address Conflict”

Introduction "Windows has Detected an IP Address Conflict" means that two computers on the network have the same IP...
Websites Like Craigslist for Gigs

Top 5 Websites Like Craigslist for Gigs

Craigslist is a local classified Ads website with 7 sections including gigs. It is a brilliant site but using other websites like...
How to Change Time Zone in Windows 10 (4 Methods)

How to Change Time Zone in Windows 10 (4 Methods)

Introduction This guide demos how to change time zone in Windows 10. Options to Change Time...

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

How to Enable RSAT for Active Directory in Windows 10 (3 Methods)

Introduction This guide demos 3 methods to enable Active Directory in Windows 10. It is not exactly enabling "Active...
ForEach-Powershell

PowerShell ForEach: Syntax, Parameters, Examples

What is PowerShell ForEach? PowerShell ForEach (ForEach PowerShell) is a PowerShell construct used in iterating through values in a...
How to Change Outlook Password in 3 Different Ways

How to Change Outlook Password in 2 Easy Steps

Introduction Before you change your Outlook Password you have to first change it with your email provider. The reason...
How to PM on Facebook

How to PM on Facebook (Send a Private Message on Facebook)

Introduction If you are looking to send a friend a private message (PM) on Facebook, you are in the...

How to Set Homepage in Google Chrome (Settings or Group Policy)

Introduction You can set homepage in Chrome (Google Chrome) 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