Excel Equations Cheat Sheet: Quick Reference for Formulas
An in-depth Excel equations cheat sheet with core formulas, syntax, and practical examples. Boost speed in arithmetic, lookups, text, dates, and dynamic arrays with concise, real-world patterns.
Core syntax and operators
Understanding the building blocks of Excel formulas is the foundation of the excel equations cheat sheet. At its core, formulas use operators like +, -, *, and /. Parentheses control evaluation order and unlock advanced patterns. For everyday math, simple addition is as easy as =A2+B2, and sum totals can be computed with =SUM(A1:A10). The relative vs. absolute reference distinction matters when copying formulas across rows and columns. For example, =A$1+$B$1 locks the row or column as needed. This section also covers operator precedence and common pitfalls, such as mixing text with numbers.
=A2+B2 -- simple addition
=SUM(A1:A10) -- aggregate range
=(MAX(A1:A10)-MIN(A1:A10))- Use parentheses to group calculations and enforce order of operations.
- When dragging formulas, use absolute references (e.g.,
$A$1) to keep certain cells fixed. - Combine functions to build compact, reusable logic.
contextVarietyNoteHRetail