Excel has over 475 formulas in its Functions Library, from simple mathematics to very complex statistical, logical, and engineering tasks such as IF statements (one of our perennial favorite stories); ...

If you've ever been confused by Excel's three different ranking functions, you aren't alone. A rank is a rank, right? But they actually differ in how they handle ties and which versions of Excel they ...