A formula is a sum the sheet does for you — and keeps doing, every time a number changes. Excel is full of them, but you only need a handful for real life: one that adds, one that averages, one that finds the biggest, and one small clever one that makes a decision. This lesson walks through each, slowly, with real numbers.
Every formula starts with an equals sign: =. That sign is the whole secret. Type =5+3 in a cell and press Enter, and the cell shows 8. Leave the = off and Excel treats what you typed as a word, and no sum happens. Real formulas point at cells instead of carrying their own numbers: =B2+B3 means “whatever is in B2, plus whatever is in B3” — and if those numbers change, the answer changes with them. The formula itself lives quietly inside the cell: click the cell and you will see the formula written out in the formula bar, the long line above the column letters, while the cell itself shows the answer.
Say column B holds four weekly grocery spends: B2 is 24, B3 is 18, B4 is 31, B5 is 12. To add them:
The shortcut: Microsoft built a button for this one. Click the cell under your numbers, then on the Home tab click AutoSum (it wears the Greek letter Σ). Excel guesses the run of numbers, shows you the formula, and one press of Enter accepts it. Check its guess covers all your numbers before you press Enter.
The first time a sheet adds for you, add the first few numbers yourself — on paper or a phone calculator — and compare. If they match, the formula is looking at the right cells and you can trust it from then on. If they do not match, the usual cause is the range: it stopped one cell early (B2:B4 instead of B2:B5), or it included the total cell itself. Click the answer cell, read its formula in the formula bar, and fix the range there.
IF is the clever one, and it is only a question with two answers. Here is a whole one, walked through slowly:
=IF(B2>100,"over budget","fine")
So if B2 holds your electric bill and it is 86, the cell reads fine. Change the bill to 120 and the same cell flips to over budget — nobody touched the formula; the answer follows the number. Two honest details: word answers must wear their quote marks, or Excel goes looking for a cell named over budget and complains; and numbers in a question never wear quotes.
Here is the good news: SUM, AVERAGE, MAX, MIN, and IF are written exactly the same way in Google Sheets and in LibreOffice Calc (which is free) — learn them once here and you know them everywhere. The Google Sheets lesson uses the very same sums. Where Excel itself differs is only in where it lives: on a computer it is a program you open, and on a phone the free Excel app does the same sums with the same formulas typed the same way — the buttons are simply squeezed into a strip you may need to open to find Home and Formulas. If you are choosing between the programs themselves, Office suites compares them in plain words.
Straight 2 Work Tech, LLC — patient, plain-words tech help.
(813) 770-6082