Compatibility functions

The functions in this category have been replaced with one or more new functions. Consider using the newer versions as they are better, the functions presented here are available for backward compatibility but may be removed in future Excel versions by Microsoft.

Old functions	New functions
CONFIDENCE function	CONFIDENCE.NORM function[2010] CONFIDENCE.T function[2010]
FLOOR function	FLOOR.MATH function[2013] FLOOR.PRECISE function[2010]
MODE function	MODE.MULT function[2010] MODE.SNGL function[2010]
RANK function	RANK.AVG function[2010] RANK.EQ function[2010]
STDEV function	STDEV.S function[2010]
BETADIST function	BETA.DIST function[2010]
BINOMDIST function	BINOM.DIST function[2010]
CHIDIST function	CHISQ.DIST function[2010] CHISQ.DIST.RT function[2010]
CHIINV function	CHISQ.INV function[2010] CHISQ.INV.RT function[2010]