Del curso: Excel: Advanced Formulas and Functions

Accede al curso completo hoy mismo

Únete hoy para acceder a más de 23.100 cursos impartidos por expertos del sector.

Compatibility functions

Compatibility functions

Del curso: Excel: Advanced Formulas and Functions

Comenzar mi mes de prueba gratis Comprar para mi equipo

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…

Contenido