Inserting Functions

Inserting Functions

The easiest way to locate and insert built-in functions is by clicking the Insert Function button. When you do, the dialog box shown in Figure 13-5 appears.

If you're not sure what function you need, enter a description of what you are trying to do into the Search box. For example, if you enter "I want to know how many cells contain values" and then press Go, the Insert Function dialog box returns a list of recommended functions, similar to the list shown in Figure 13-6. As it turns out, the first function in the list of suggestions fills the bill. If you don't find the function you're looking for, try rewording your query.

Figure 13-6. Ask ...

Get Microsoft® Office Excel 2003 Inside Out now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.