![]() ![]() Since the user is not really meant to see this sheet, we don’t have to worry as much about making this sheet pretty. Now, we want to put the required formula in A1 in the Formulas sheet. After that, the “A1” tells Calc to find the answer on the cell “A1” on that sheet. Next, the period tells Calc that it’s the end of the name of the sheet title. Breaking this down, the cell is telling calculate to refer to the sheet “Formulas”. ![]() So avoid sheet titles with a space in it. If you reference the sheet with a space in its title, the space tends to mess up your formulas. Important Note: Don’t use sheet names with spaces in them. First, I’m going to tell it to reference the “Formulas” sheet and tell it to look for the answer in the cell “A1”. In this case, I’m going to start with what I need to get an A minus. The second sheet is going to be designated the sheet for formulas.įirst, I want to click on the cell in the “Main” that I want the result to pop out at. I’m going to designate the first sheet as the main sheet because that is what is going to be opened when you open the file. ![]() So, let’s build a spreadsheet that tells me what I need to get a certain letter grade on a test or paper.įirst, let’s create a two page spreadsheet. This can eliminate some of the visual clutter while producing a clean looking spreadsheet. Sometimes, you’ll want to move your equations off into another place in the spreadsheet. Pretty neat! You didn’t even have to know any math and you’ve already built a calculating machine! Just remember to hit enter when entering the second number for the formula’s to do the work. Just type in any two numbers and the machine will add, subtract, multiply, and divide those two numbers. Now, your Any Two Numbers machine should work. This is normal because you can’t mathematically divide by zero. The division formula, however, will spit out the error message “#DIV/0!” Don’t worry about it. You’ll likely notice that for the first three, the resulting number is zero. Finally, for division, use the formula “=B4/F4”. Hit enter and you’ll have your subtraction formula covered.įor the multiply box, insert the formula “=B4*F4”. Now, click on the subtraction box and insert the formula “=B4-F4”. This, of course, provides you with a great clue on how to create the formulas for the rest of the calculations. This will also calculate the addition of two numbers. Select your addition box, then change the formula to “=B4+F4”. Now, there is an alternative and even better way to add two cells. Go ahead and test out your machine to see if two numbers add properly. If you click on the cell, the formula will appear on the top line while the answer will appear in the box in your spreadsheet. This is because you are not adding any two number, so if nothing is getting added, then the answer is zero. You should see a “0” appear in the “Added” box. Either way, when you are done, hit “Enter” on your keyboard. In this case, it is “F4”.Īlternatively, you could also just manually type the formula “=Sum(B4,F4)” which will also point to those two cells. Next, we’re going to hold down the “CTRL” button on the keyboard and click on the other box the user is going to insert a number. The easiest thing to do is click on the first box the user is going to insert their number. When you make that click, you’ll see the box above spit out “=Sum()”. Next, we are going to click on the “Sum” button which looks like a funny looking “E” (as highlighted in the screen shot). In this case, we’re starting with the blank “Added” box. This is where the formulas come in handy.įirst, we need to select the cell we want to put the resulting number in. Of course, right now, if I put a number in both spaces, nothing will get spat out in the four blocks below. Don’t worry, you won’t be doing any of the math. From there, the machine will add, subtract, multiply, and divide both numbers. The idea is that you can type in one number in one space and another number in another space. It’s by no means perfect, but we have a general idea of what we want to see. So, I came up with the Any Two Numbers Machine. So, I decided to try and build a simple calculator. Formula’s don’t actually have to be all that complicated, but once you grasp the basics, you can do a lot with a spreadsheet once you throw in some math.įirst, you need a general idea of what your spreadsheet is going to look like. While this can really make your spreadsheet shine, a formula can really make your spreadsheet seem magical. Previously, we discussed how to add some visual appeal to our spreadsheets. This can really add magic to a spreadsheet. In this fourth part of our guide on Calc, we start exploring how we can add formulas and manipulate data in a spreadsheet. ![]()
0 Comments
Leave a Reply. |