Loading…
Loading…
Excel is a grid of cells. Each cell has an address made of its column letter and row number, such as B3. A cell can hold a value (text, a number, a date) or a formula. Formulas always start with = and recalculate automatically when the cells they use change.
Syntax
=A2*B2
Example: If A2 is 12 and B2 is 5, the formula =A2*B2 shows 60. Change A2 to 10 and it instantly shows 50.
Common mistakes
Read the lesson, then try it yourself in a live spreadsheet.