Excel has over 475 formulas in its Functions Library, from simple mathematics to very complex statistical, logical, and engineering tasks such as IF statements (one of our perennial favorite ...

designer491/Getty Images The internal rate of return (IRR ... don’t have regular intervals. Using the Functions in Excel: IRR Here is a simple example of an IRR analysis with cash flows that ...

To take advantage of Excel’s currency conversion capabilities, use formulas: Reference Prices and Rates: Click on the cell, ...

More specifically, I will explain the Future Value (FV) and Number of Periods (NPER) functions in Microsoft Excel ... example. Suppose you invest $5,000 at an annual interest rate of 5% ...

Excel for the web fully supports COUNTIF(). To follow along with our specific examples, you can download the demonstration file here. Jump to: Can the COUNTIF function reference a cell?