课程: Excel: Advanced Formulas and Functions

今天就学习课程吧！

今天就开通帐号，24,600 门业界名师课程任您挑！

Compatibility functions

Compatibility functions

课程: Excel: Advanced Formulas and Functions

开始一个月试用 购买团队方案

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…

内容