- Charts
- Formula
- Printing
Formula Tips
- A formula to calculate a ratio
- Alternatives to nested IF functions
- Creating a "megaformula"
- Transforming data with formulas
- Summing times that exceed 24 hours
- Force a global recalculation
- Counting distinct entries in a range
- Hiding your formulas
- Change cell values using Paste Special
- Avoid error displays in formulas
- Round values to the nearest fraction
- Delete all input cells, but keep the formulas
- Referencing a sheet indirectly
- Change the formatting of your subtotal rows
- Perform math operations without formulas
- Perform two-way table lookups
- Count AutoFiltered rows
- Sum the largest values in a range
- Using Data Validation to check for repeated values
- Working with pre-1900 dates
- Rounding to n significant digits
- Calculate the day of the year and days remaining
- Automatic list numbering
- Text and values in one cell
- Calculating a conditional average
- Displaying AutoFilter criteria
- Identify formulas using Conditional Formatting
- Calculate the number of days in a month
- Compare ranges by using an array formula
- Converting non-numbers to actual values
- Dealing with negative time values
- Locate phantom links in a workbook