From the course: Excel: Advanced Formulas and Functions

Unlock the full course today

Join today to access over 23,100 courses taught by industry experts.

Compatibility functions

Compatibility functions

From the course: Excel: Advanced Formulas and Functions

Start my 1-month free trial Buy for my team

Compatibility functions

“

- [Instructor] So let's say that you are inquisitive, and you have gone into Formulas. Okay, and there are all the categories of formulas, and then you go here, More Functions, and then you get Compatibility. Okay, so in Compatibility, beta distribution, floor, forecast. There's a lot of functions here. Also, if you were to go and do something like this. So you say equals, rank. Oh, now you see that little triangle by rank, and also by percent rank. They are letting you know that these are compatibility functions, which means they exist in Excel today only for compatibility purposes with any old yesteryear functions that are still using rank, percent rank, et cetera. It's also strongly suggesting to you that you use something else. So, I'm going to show you three compatibility functions, and what they do. Let's escape out of there. All right, so, rank. We have values over in column B and I want the rank, so…

Contents