footopk.blogg.se

A mathematical formula would look like +D2+C2 or +2*3. Users of Lotus 1-2-3®, Quattro Pro® and other spreadsheet software may be familiar with formulas that begin with +, -, =, (. If C31 = 144, then HIGH is displayed, otherwise OK is displayed. Formulaĭisplays the contents of cell A1 plus 10.ĭisplays the result of the multiplication of A1 and A2.ĭisplays the contents of cell A1 rounded to one decimal place.Ĭalculates the effective interest for 5% annual nominal interest with 12 payments a year.Ĭalculates B8 minus the sum of the cells B10 to B14.Ĭalculates the sum of cells B10 to B14 and adds the value to B8.ĭisplays the average of a named range defined under the name BloodSugar.ĭisplays the results of a conditional analysis of data from two sources. For example, in the entry '= means different things to different people, Calc treats everything after the single quotation mark-including the = sign-as text. 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.

You can enter formulas in two ways, either directly into the cell itself, or at the input line.