From the course: Excel: Advanced Formulas and Functions

Unlock this course with a free trial

Join today to access over 25,600 courses taught by industry experts.

Compatibility functions

Compatibility functions - Microsoft Excel Tutorial

From the course: Excel: Advanced Formulas and Functions

Start my 1-month free trial Buy for my team

Compatibility functions

“

- [Instructor] In this dataset, we have restaurants in column B sorted alphabetically, and we have their ratings. Now we want to rank these restaurants, but we're going to discuss this within the context of compatibility functions. Now, watch this. Where does 7th Avenue Lounge rank as far as this 6.5 out of 10 rating? Wow, 6.5, I don't know if we want to eat there. Anyway, let's get focused. =RANK. Notice, the yellow caution symbol by RANK. Let's click on RANK. Notice, this function is available for compatibility with Excel 2007 and earlier. Let's look at PERCENTRANK because it also has this caution symbol, again, Excel 2007 and earlier. But let's exit out of this and look at this a little deeper. This screen capture is from the Microsoft website. We're looking at the RANK function, there's a description of what it does, but now look at the gray box where it says important. It says, "Although this function…

Contents