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 O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.