Start with the equals sign and the inputs

An Excel formula begins with an equals sign and can contain constants, references, operators, and functions. The source explains why referring to existing cells is often more convenient than repeatedly typing fixed values into expressions. A reference such as A1 connects the formula to information in a specific row and column. Understanding those basic components makes an unfamiliar calculation less mysterious and easier to inspect.

Control how references behave when moved

Relative references adjust when a formula is copied to a new position. Absolute references, such as $A$1, keep the same location, and mixed references preserve only part of the address. Those choices affect the result when filling formulas down or across a table. Before copying a calculation, identify which inputs should move and which must remain fixed. A formula's first correct answer does not guarantee that every copied instance will use the intended cells.

Learn the Parts of an Excel Formula Before Copying It