Using Excel’s Built-In Functions

  • Guy Hart-Davis


As you saw in the previous chapter, a function is a predefined formula for performing a standard calculation. Excel includes several hundred built-in functions that you can simply insert in a cell and provide with the data they need to deliver the answer. Functions save you from having to create complex formulas from scratch and from getting such formulas wrong, so when you need to perform a standard calculation, check whether Excel has a function for it. There’s no point in reinventing the wheel, especially if the result isn’t round.


Interest Rate Cash Flow Serial Number Maturity Date Treasury Bill 


Unable to display preview. Download preview PDF.

Unable to display preview. Download preview PDF.

Copyright information

© Guy Hart-Davis 2011

Authors and Affiliations

  • Guy Hart-Davis

There are no affiliations available

Personalised recommendations