🟡 Intermediate 10 minintermediate path
TODAY, NOW, ROUND, ROUNDUP, ROUNDDOWN, IFERROR
A tidy roundup of utility functions you'll use in almost every workbook.
Learning objectives
- Insert live dates and times.
- Round numbers consistently.
- Suppress ugly error messages with IFERROR.
Step-by-step
1. TODAY / NOW
=TODAY() returns today's date; =NOW() returns date+time. Both recalculate whenever the sheet recalculates.
2. ROUND family
=ROUND(A2,2) to 2 decimals, ROUNDUP to always go up, ROUNDDOWN to always go down. Use these on currency to avoid pennies drift.
3. IFERROR
=IFERROR(risky_formula, fallback). Turn #N/A and #DIV/0! into a blank or friendly text.
Key takeaways
- Insert live dates and times.
- Round numbers consistently.
- Suppress ugly error messages with IFERROR.
Related lessons
Excel Basics: The Ribbon, Cells, and Saving
12 min • Beginner
Your First Formulas: SUM, AVERAGE, and Basic Math
15 min • Easy
Lookups: VLOOKUP and XLOOKUP Explained
20 min • Intermediate
Pivot Tables in Under 20 Minutes
20 min • Advanced