Advertisement

Using Excel’s Built-In Functions

  • Guy Hart-Davis

Abstract

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.

Keywords

Interest Rate Cash Flow Serial Number Maturity Date Treasury Bill 
These keywords were added by machine and not by the authors. This process is experimental and the keywords may be updated as the learning algorithm improves.

Preview

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