Calc Guide

Figure 157: Structure page of Function Wizard
After you enter a function on the Input line, press the Enter key or click the Accept
button on the Function toolbar to add the function to the cell and get its result.
1
Name Box showing list of common functions
2
Function Wizard
4
Accept
3
Cancel
5
Input Line
Figure 158: The Function toolbar
If you see the formula in the cell instead of the result, then Formulas are selected for
display in Tools > Options > OpenOffice.org Calc > View > Display. Deselect
Formulas, and the result will display. However, you can still see the formula in the
Input line.
Strategies for creating formulas and functions
Formulas that do more than a simple calculation or summation of rows or columns of
values usually take a number of arguments. For example, the classic equation of
motion s = s
0
+ vt - ½at
2
calculates the position of a body knowing its original
position, its final velocity, its acceleration, and the time taken to move from the initial
state to the final state.
180 OpenOffice.org 3.3 Calc Guide