- Rank Scores
- Rank a List Without Ties
- Sorting with a Formula
- Round Numbers
- Round to the Nearest $0.05 with MROUND
- Round Prices to the Next Highest $5
- Round 0.5 towards Even Per ASTM-E29
- Separate the Integer From the Decimals
- Why Is This Price Showing $27.85000001 Cents?
- Calculate a Percentage of Total
- Calculate a Running Percentage of Total
- Use the ^ Sign for Exponents
- Raise a Number to a Fraction to Find the Square or Third Root
- Calculate a Growth Rate
-
- Find the Area of a Circle
- Figure Out Lottery Probability
- Help Your Kids with Their Math
- Convert Units
- Match Web Colors with HEX2DEC
- XOR Find People Who Chose a Single Value?
- Find the Second Largest Value
- Format Every Other Row in Green
- Use IF to Calculate a Bonus
- IF with Two Conditions
-
- Tiered Commission Plan with IF
- Display Up/Down Arrows
- Stop Showing Zeroes in Cell Links
- Count Records That Match a Criterion
- Build a Table That Will Count by Criteria
- Sum Records That Match a Criterion
- Can the Results of a Formula Be Used in SUMIF?
- Calculate Based on Multiple Conditions
- Avoid Errors Using IFERROR
- Multiple Conditions Using SUMPRODUCT
- Use VLOOKUP to Join Two Tables
- Every VLOOKUP Ends in False
- Lookup Table Does Not Have to Be Sorted
- Beware of #N/A from VLOOKUP
- Add New Items to the Middle Of Your Lookup Table
- Consider Naming the Lookup Table
MORE RESOURCES
FOR MICROSOFT EXCEL
