Spreadsheet Formulas in Google Documents

Next Video:
Finance Formulas in Google Documents....5

Using spreadsheet formulas in Google documents is easy with these tips, get expert advice on business software and the internet in this free video.

Part of the Video Series: How to Use Google Documents
Promoted By Zergnet


Video Transcript

DREW NOAH: So now, I'm going to talk about using formulas in--on a Google Spreadsheet. And if you're used to using these in a program like Excel, this will probably all seemed very familiar to you. But if you're not used to using them, Google makes it very easy to just go right in and make simple formulas. So you see I'm on the Formula tab right here, and if you go all the way over, you've got your most basic formulas right here, Sum, Count, Average, Min, Max and Product. So the easiest way to create a formula is this is where I want my result to be, so I click on Sum and you can see it starts it for me. If I just want to type this in, I could but it's so much easier just to come to the formula tab and click it. And then I can make a sum by selecting a row of columns or cells, excuse me, and just by shift-clicking or clicking this and then shift-clicking down here, you can see now it's H6 through H19. And I can either close it or can just hit Enter right here and I get a number. So that's the easiest way to make a formula real fast. I mean you can also--you can maybe do just like one and then add your own, like, plus symbol and click another one and hit Enter, and just do it manually like that. But if you're just going to do a whole bunch of cells and they're next to each other, which is likely if you set your document up right, that's how it should be, you can just click one and then shift-click all the way down. So that's the Sum which is pretty much the most basic, easiest-to-use formula. And then you've got some others here. The Count is, basically, it will tell you the number of cells selected that include numbers, and it will ignore text. Oops. Go ahead and get rid of that. If you have an error, this is the kind of thing that's going to come up. Average will just give you the average of all the numbers you select. Let me go through all these again. Hit Enter, I get an average. Just going to delete that. The Minimum will give you the lowest number in selected cells. The Maximum will give you the highest number in selected cells, and the Product will give you all the selected cells multiplied. So those are the most basic formulas and--but there's also there's More option and there's just a whole lot more formulas right here, and you can see there's just a ton. I mean, this is just in the math section, and then there's Financial, Logical, Date, Lookup, Statistical, Text, Info, and then some special Google formulas. But just real quick, if you need to know what something is, you just come right down here to the More, and it will open up the Google Help in another page. And then it brings you to the help page. It's all about formulas right here. And a good way to--if you are looking--if you're on this page and you're looking for the definition of a formula, a good way to do it is use the Find function in your Web browser and then type the formula if you know exactly what it is and then put that parenthesis right there and then you'd get to it pretty fast. I mean, there's a couple of different ones with product in it. But you can see now, I'm just right at the regular Product one. So they're all right here on the same page, but if you use the Find function in your Web browser you can look them up more easily. So that's using the formulas in a Google Spreadsheet.


Related Searches

Is DIY in your DNA? Become part of our maker community.
Submit Your Work!