1,413
edits
Changes
From Open Educational Resources
→Inserting formulae for computations
<gallery mode="packed" heights="350">
<gallery mode="packed" heights="350">
File:LO Calc 3 Processing the data Summing up rainfall information.png|Inserting Formulae
File:LO Calc 3 Processing the data Summing up rainfall information.png|Inserting Formulae
</gallery>
You can do almost any kind of computation or processing with a spreadsheet. Here we will calculate the total rainfall for the cities. You can go to the cell below last row with data in Column B, which has the rainfall information and simply type in “=Sum(B2:B15)” assuming the data is in rows 2 through 15 of column B. Any computation or formula must begin with the “=” sign. Or you can simply use the shorthand icon on the menu bar “∑” and hit enter and the application will insert the same formula.
You can do almost any kind of computation or processing with a spreadsheet. Here we will calculate the total rainfall for the cities. You can go to the cell below last row with data in Column B, which has the rainfall information and simply type in “=Sum(B2:B15)” assuming the data is in rows 2 through 15 of column B. Any computation or formula must begin with the “=” sign. Or you can simply use the shorthand icon on the menu bar “∑” and hit enter and the application will insert the same formula.
