Introduction to the formula bar

The formula bar is where you can build formulas, using functions, to manipulate, refine, and perform calculations on your data. See How to use the formula bar for more information.

Type-in Formula

This article includes:

How do I build and edit 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.

 

How do I view all the available functions?

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

Where can I learn more about a function?

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.

More information about individual functions can also be found here.

Have more questions? Submit a request