The Formula

Directly below the formatting bar in a default OpenOffice.org Calc setup is the formula bar. Table 7-4 lays out what you find in this short collection of entries. The formula bar actually changes depending on what you're doing, offering you buttons for particular tasks.

Table 7-4: The Calc Formula Bar

Button or Item

Description

Name Box

Displays the current cell name. This can be in either the generic

ColumnRow format (such as A1 or B5) or a text name that you specify

for a specific cell.

Function Wizard

Click to open the Function Wizard dialog box and browse to find the

particular spreadsheet function you're looking for.

Sum

Click to start a SUM (addition) function in the input line.

Formula Textbox

Click to place an = in the input line to signal that you're about to enter a

function.

Input Line

Assign values or enter functions to fill a spreadsheet cell.

The Function wizard is a great tool for seeing the functions available in Calc and for getting a bird's eye view of your own formulas as you enter them into cells.

Was this article helpful?

0 0

Post a comment