Excel will show the #NUM error if a formula uses a function that iterates, such as IRR or RATE, and cannot find a result. Follow the steps below to change the number of times Excel iterates formulas: ...

Periodic Rate Functions in Excel. Microsoft Excel 2010 can be a huge help for a business when it comes to crunching the businesses numbers. Excel has a number of financial functions revolving ...