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]

Compatibility Functions

Table of Contents How to use the BETADIST function How to use the BETAINV function How to use the BINOMDIST […]

Find the most recent date that meets a particular condition

This article demonstrates how to return the latest date based on a condition using formulas or a Pivot Table. The […]

How to rank text uniquely without duplicates

Table of Contents How to rank text uniquely without duplicates How to rank uniquely based on a condition Get Excel […]