the XLOOKUP function is used to find things in your data tables. This goes past being a glorified Ctrl + F command because ...

To convert the APR to a periodic rate in Excel, simply place "=.06/12" into a cell but change the ".06" to your APR and the "12" to the number of periods per year. Advertisement Article continues ...

Users will appreciate a chart that updates right before their eyes. In Microsoft Excel 2007 and Excel 2010, it's as easy as creating a table. In earlier versions, you'll need the formula method.