How to Make Formulas in Google Sheets | How to Add, Subtract, Multiply & Divide in Google Sheets

In this video, we will show you how to create simple formulas in Google Sheets.

Google Sheets can perform calculations by using simple formulas. Let’s look at the sheet over here. We want Google Sheets to do some basic calculations here.

All formulas must begin with an equals sign in Google Sheets.

Now we can use standard operators for the formulas here. Instead of manually having to type the entire calculation, for example sixty four plus two hundred - we can simply select the cell which contains the data.

So for example, over here we will select Cell C 4, that is column C, row 4. Now we will enter the plus sign and after that we will select Cell D 4, that’s column D, row 4. C4 and D4 here are just cell references which allows the formula to automatically get the value within the cell and perform the function.

Once you're done, simply hit enter and the formula will calculate the value and show the result in the cell the formula had been entered in.

So in this case it automatically added sixty four with two hundred. The benefit over here is that whenever we change the value in the cell which is referenced in the formula, Google Sheets automatically updates the value as a result.

So for addition, we used the plus sign.

For subtracting two values, we use the minus sign. Similar to what we did previously, we will select the first cell, enter the minus sign and select the second cell.
Now for division, we use the forward slash sign.

And finally for multiplying the two values over here, we will use the asterisk key on the keyboard.

To edit the formula you’ve entered in a cell, simply double click on it. Instead of the value, Google Sheets will show you the formula. You can simply make the changes here and hit enter.

For example, let’s multiply the whole value by two. For that, we will enter two after the equals to sign, and put the remaining formula within brackets. This means, whatever is calculated over here will be multiplied by two.

To make the changes visible, simply hit enter and the formula will show you the result.

That’s all!

❓💬 Would you like to know about any particular Google Sheets feature? Let us know in the comments below.

#HowTech #GoogleSheets
--------------------------------------------------------------------------------------------------------------

[nicoleo.]

Exactly was I was looking for! Needed a quick and straightforward video with simple functions.

[jrnqyzj]

Broo the best and quickest vid I ever seen ❤️

[Andreey]

Straight to the point and simple !
thx alot !

[nicklatsu]

Thanks man, your videos are really useful😊.

[RalphErvin]

Thanks for this. How do you subtract then divide with the result in the same self? For instance, cell a3 is 15 - cell b2 is 14, /2 is .5. Thanks!

[pakmehndeart]

fantastic sir
you make it easy for me. Jazakallah khairn

[kc]

Does or Can Google Sheets add more than 2 cells? Adding 2 is easy but when i try something like C10+C17+C24+C31, I only get the contents of the first two. It will not add the contents of 3 or 4 cells. The formula I am using is =(Jan!C10+C17) I have a main summary page Annual (tab), and I am trying to get the contents of every monday in January (Tab) add them up and divide by 4 to get an average.

[Simonthepieman]

If anyone knows how to make a column that is essentially a running total of the difference from the first data point, please let me know. I am making a weight loss sheet that I input my weight every day and want a 3rd column that is just a running total of loss. So, essentially the first data point minus each data point.

[lifewithtashabae]

How do I get it to add horizontal? Like for a profit calculator ?

[painfullyhonest]

what if I have two fields one says Pay-in and one says pay-out. how could I make a 3rd field add or subtract the first two and determine whether there was a gain or loss?

[dmaxey]

Does anybody know if I can setup a formula for a cell where lets say I want to multiply whatever the input is by "2". so if I enter 2 in the cell it will show 4?(because 2x2 is 4.. I think)