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 ...

Excel offers three functions for calculating the internal rate of return, and I recommend you use all three.

Q. I have an Excel spreadsheet that contains errors because some of the numbers that are part of the calculations are blank or zero. Is there a way to have Excel automatically return something instead ...