Getting to know the formula bar

Type-in Formula

The formula bar

The formula bar is where you work with your data by building formulas that manipulate, refine, and perform calculations on values in your data source. See tips for using the formula bar for more information.

Building and editing formulas

The Formula Bar allows you to type-in formulas or select from a list of functions. When you start typing a function name in the Formula Bar, a list of functions filtered by the letter you entered is displayed. Online help with examples and parameters automatically display for each function in a pop-up window.

To start building a formula, you can click on Insert or just start typing in the Formula Bar. When you select Functions from the Insert menu, a list of functions displays.

 

If you know the function you want, just start typing.

Browse a list of functions

To see all the functions available for building formulas, click Insert, select Functions and then click on the Browse All Functions link. 

Getting Help

When you select a function, a help pop-up displays with a description, examples and parameter information. You can dismiss the Help pop-up by clicking the X in the dialog and reactivate it at any time with the Show Function Help button.

Functions

Learn more about functions in these articles: