OpenOffice Tutorial: Enter formula in cell
- To enter a formula into a cell, first double click on it.
- Now in calc, like in other spreadsheets, formulas always start with the equal (=) sign. Type this in first.
- For this example we are doing a simple addition or sum formula.
- To do this, we must add items to the formula. Just click once on a cell with the value that you want to add.
- Good! Note that the cell's borders have a red outline indicating that the cell's values will be included in the formula.
- Also note that the cell's reference "F2" has been automatically typed in.
- Now, to perform the addition type in the "plus" (+) sign after the first item.
- Repeat the process for the other items you want in the formula. Just click on the next cell with the value.
- Then type in the plus sign...
- then click on the next cell...
- Now, Just go through the process again until all the items you need are in the formula.
- Afterwards, once you have inputted all the cell values needed for the formula. just press enter.
- Great! The addition has been done. Note that the sum of the process has appeared where we put the formula in.
- Also take note that when you click on the cell, the formula appears here on the formula bar.
- Congratulations! You have learned how to enter formulas in cells.
by Kaj Kandler
Enter formula in cell
This screencast demonstrates how to enter a formula in a cell. You learn:
- How to start a formula as content of a cell.
- How to enter a cell formula.
- How to select cell references for the formula.
- How to calculate the value of the formula.
For advanced functionality with similar results see:
- Enter a reference to a another cell.
- Enter the sum of a range of cells.
- Enter the sum of a cell range using the keyboard.
- Enter the sum of a cell range using the function wizard.
OpenOffice.org™ is a registered trademark of Oracle.
LibreOffice™ is a trademark of The Document Foundation.