Excel® 2013 On Demand

Using Compatibility Functions

Excel has replaced several functions with new functions that provide improved accuracy and whose names better reflect their usage. For example, STDEVP has been replaced with STDEV.P. If you want to use an older version of a function for backwards compatibility in order to share your worksheets with those who do not have Excel 2013, you can use the Compatibility menu on the Formulas tab or the Compatibility option in the Insert Function dialog box to display and select the old function you want. When you enter a function, Formula AutoComplete lists both renamed and compatibility functions. If compatibility is not an issue, you can use the new functions, which are available in the different function categories. Before ...