Making Calculations with Functions

Excel is jam-packed with functions that can make you look like a financial wizard or a mathematical genius (if you aren’t either or both of those already, of course!). Do you want to know the standard deviation of a series of numbers? What about the sum of the squares? How about calculating the number and amount of the payments needed to retire a loan over a certain period? If you’re a real stickler for precision, you can even use a function that returns the value of pi, accurate to 15 digits.

Find a Function

  1. Click in the cell in which you want the results of the function to be displayed.

  2. Click the Insert Function ...

Get 2007 Microsoft® Office System Plain & Simple 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.