Chapter 6. Function Fundamentals

The Basic Parts of a Formula

A function in Excel is a built-in formula that performs a mathematical operation or returns information specified by the formula. For example, if you had a list of a thousand numbers and wanted to manually look for the highest value, it could take a while. That’s where Excel can help. It has a MAX function that searches a specified range and returns the highest value. Using another example, if you wanted to calculate the average ...

Get Special Edition Using® Microsoft® Office Excel 2003 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.