Microsoft Office Tutorials and References
In Depth Information
Using Worksheets with Legacy Function Names
Furthermore, if you are creating a new workbook in Excel 2013 and that work-
book will be shared with people who are using Excel 2007 or earlier, you
pretty much have to keep using the old naming convention.
Still, Microsoft is hopeful that people will start using the new naming
scheme. In the Statistical function drop-down, the new names appear. The old
names have been moved to the Compatibility drop-down.
As you start to type a function name, the formula AutoComplete always
lists the new names first. The old names are listed at the end with a symbol
to indicate that it is here for compatibility only.
Table 14.3 compares the old and new function names.