How to rank data in Excel tables

How to rank data in Excel tables

Sure, it’s easy to find the highest or smallest values in a data set. But what if you’re looking for the 3rd, 10th, 20th rank in a large table, or need to do this in ascending and descending order? Luckily, Excel features a formula that does just that....
How to use multiple IF functions

How to use multiple IF functions

The IF function is great for creating a logic statement. But IF is an either/or argument, what if you need more alternatives? Combining several IF statements in a nested structure can help overcome this. Syntax =IF(first logical test, do something if first test is...