If you have to share your worksheet with other people who do not have Excel 2010 installed, you can use the compatibility functions instead of the renamed functions. Earlier versions of Excel recognize the old names and provide the expected results.

Finding compatibility functions

To find all compatibility functions, do the following:
Tip  You can also access the compatibility functions in the Function Library group. (Formulas tab, Function Library group, More Functions, Compatibility).

Selecting the right function in the worksheet

When you start entering a function in the worksheet, Formula AutoComplete lists both renamed and compatibility functions. Distinguishing icons make it easier for you to click the one that you want to use. The original functions are displayed with a yellow triangle to notify you that these functions are available for compatibility with Excel 2007 and earlier.