# The mathematical operators used in Google Sheets

Last updated Jul 09, 2022

You will need to perform a variety of mathematical operations when working with numbers in Google Sheets. Formulas are used to perform mathematical operations. Formulating your mathematical problem requires you to know how to use the Google sheet mathematical operators.

With Google Sheets, you can perform many mathematical operations, making it ideal for data analysis. This article will cover the mathematical operators that you can use if you are unfamiliar with the built-in routines.

The Common Operators in Google Sheets

Here are the common operators you can use to carry out mathematical operations.

The Subtraction operator (-):  Using this operator, we can subtract between two or more numbers in different cell references. In this case, we are subtracting A1 from B1.

Pressing enter on your keyboard will display the answer in cell C1

The Addition operator (+): You can use this operator to add two or more numbers in two or more cell references. Here, we are adding A1 and B1.

If you press enter on your keyboard, the answer will appear in cell C1

The Multiplication (*) operator: By using this operator, you can multiply numbers across two or more cell references. Here, we are multiplying A1 by B2.

Pressing enter on your keyboard now displays the answer in cell C1

The Division operation (/): By using this operator, you can divide numbers between two or more references. For this example, we will divide A1 by B2.