To enter the = symbol for a purpose other than creating a formula as described in this chapter, type an apostrophe or single quotation mark before the =. If the data needed was on different worksheets they would be referenced by referring to the worksheet, for example =SUM(Sheet2.B12+Sheet3.A11). These cell references allow formulas to use data from anywhere in the worksheet being worked on or from any other worksheet in the workbook that is opened. Other ways of entering formulas are shown in Table 1. ![]() The plus sign indicates that the contents of cells B3 and B4 are to be added together and then have the result in the cell holding the formula. ![]() Note that the formula was shown as =B3 + B4. In this case, cells B3 and B4 were the data holders with B5 the cell where the calculation was performed. While the calculation on the left was accomplished in only one cell, the real power is shown on the right where the data is placed in cells and the calculation is performed using references back to the cells. A mathematical calculation like 15 + 46 can be accomplished as shown below. With formulas, the equals sign indicates that the cell will be used for a calculation. Entering data is accomplished simply by typing in the cell and moving to the next cell or pressing Enter. Starting with anything else causes the formula to be treated as if it were text.Įach cell on the worksheet can be used as a data holder or a place for data calculations. Either way, you need to start a formula with one of the following symbols: =, + or. Using IF/ElSE statements in OpenOffice Calc can quickly take your spreadsheets to a much higher level of usability.You can enter formulas in two ways, either directly into the cell itself, or at the input line. The examples may be very simple but the idea can be applied to many instances. Now for the final total for employee salary a fifth column would be added that would look like: So the forumla for the third column would be a standard:Īnd the formula for the fourth column would be: Overtime is standard time and a half pay. For simplicity's sake all employees make $10.00 an hour. So we'll add a fourth column for bonuses. Say if an employee worked over 5 hours of overtime they would gain an extra 100 dollar bonus in their check. The formula for the second column would look like this:įor the third column let's continue with this idea. But let's say you also have to account for zero hours worked. The third column will represent how much overtime pay they made. The second column will represent how many hours over 40 they worked. The first column is a number that represents how many hours an employee worked. For this example we'll have three columns. What this will do is enter a "2" in the third cell is the employee is bringing a guest and a 1 if they are not. ![]() The formula to enter into the third column would look like: The first column will represent the name of the employee and the second column is how many guests the employee will bring. To make things easy if the person enters "0" that means they are not bringing a guest (the employee, however, IS required to come) and if they enter "1" that means they are which means that employee equals two attendees. We'll do a simple spreadsheet that deals with how many persons each employee will bring to a company picnic. The first example will illustrate a basic IF/ELSE statement that uses only two columns of data. Let's start out with a more simple example and move on to a more complex example. IF entry A is greater than B THEN C is X ELSE C is Y.īut how does one do this? It's actually quite easy. That third columns' entry will depend upon the information in the first two. ![]() Let's say you have two columns of numbers and you want to add a third column based on the other two data.
0 Comments
Leave a Reply. |