OmniDocExcel Formulas Tutorial With Step-by-Step Examples
Learn Excel formulas through a small worked table: build each formula step by step, fill it down, and check results when they look wrong.
If you searched for an excel formulas tutorial with examples, you probably face one of two problems. Either a formula you wrote returns a number that looks wrong, or you inherited a spreadsheet full of calculations you don't yet understand. Both are easier to fix when you learn formulas through a few worked examples instead of a long list of functions.
This guide uses a small sales table with five rows. You will build each formula step by step, copy it down a column, and check the result against a number you calculated yourself. The table takes a few minutes to recreate, and the same steps apply to any workbook you open.
You will also learn how cell references let one formula work across many rows, and how to read the error codes that appear when something is wrong. The goal is to understand what each formula does, so you can adapt it to your own data.
How do you learn Excel formulas with examples? The short answer
Build a small table you understand, write one formula at a time, and check each result against a value you calculated by hand.
| Your situation | What to do | Why |
|---|---|---|
| You are new to spreadsheets | Start with multiplication and SUM on a five-row table | Simple results are easy to verify without the computer |
| You need the same calculation on many rows | Write the formula once, then fill it down | Relative cell references update automatically for each row |
| A formula returns an error | Read the error code, then check the cells it refers to | Each error code points to a specific type of problem |
| A result must depend on a condition | Use IF with one clear yes-or-no test | One formula handles every row the same way |
| Your data is in a PDF table | Export it to Excel format, then build formulas | Formulas need cells, and PDFs store text and lines, not calculations |
Before you start
- Work on a copy. Testing formulas on a copy means a wrong formula cannot overwrite the original numbers you need to keep.
- Put headers in row 1. Labels such as Item, Units and Unit price make each column easy to read, and they keep your formulas readable later.
- Confirm your numbers are numbers. A value stored as text will be ignored by SUM and AVERAGE. Numbers usually align to the right of a cell, while text aligns to the left.
- Check whether your PDF has real text. Select one line of text in the PDF. If the selection highlights the words, the file is digital. If nothing highlights, the file is scanned and needs OCR before you can copy its values. OmniDoc's desktop client can OCR scanned PDFs, and its PDF editor can export a document to Excel format.
Building your first Excel formulas, step by step
Use this sample table. Type it into rows 1 to 6, starting in cell A1.
| Item | Units | Unit price |
|---|---|---|
| Notebook | 4 | 3.50 |
| Pen | 12 | 0.80 |
| Stapler | 1 | 9.00 |
| Folder | 6 | 1.25 |
| Tape | 3 | 2.40 |
- Type the sample table. Enter the headers in row 1 and the five items in rows 2 to 6. Keep one value in each cell so every formula has a clear target.
- Write a line-total formula. Click cell D2, type
=B2*C2, and press Enter. The equals sign tells the program a formula follows. The notebook line total is 14.00, which is 4 units times 3.50. - Fill the formula down. Copy D2 and paste it into D3 through D6, or drag the small square at the corner of D2 down to D6. Each row now uses its own units and price, because the references shift from B2 and C2 to B3 and C3, and so on.
- Add a total with SUM. In D7, type
=SUM(D2:D6). The range D2:D6 tells the formula which cells to add. The total is 47.30. - Find the average unit price. In C8, type
=AVERAGE(C2:C6). This averages the five unit prices and returns 3.39. Averages describe a typical price, not the total spend, so keep the two results separate in your head. - Flag high-value lines with IF. In E2, type
=IF(D2>8,"Over 8","8 or less")and fill it down to E6. The formula checks the line total in column D. Notebook and pen both show "Over 8" in your results, while folder and tape show "8 or less." Stapler is exactly 9.00 and also returns "Over 8," which is the expected outcome for a value above 8.
Keep the quotation marks in the IF formula, since they mark the text that appears in the result.
Check the result
After you build formulas, check each result before you rely on it. The table below covers the checks that catch most beginner mistakes.
| Check | How to see it | If it's wrong |
|---|---|---|
| The total matches your own math | Add the line totals with a calculator | Look for a range that skips a row, such as D2:D5 |
| The formula points at the right cells | Click the result cell and read the highlighted references | Correct the reference, or use $C$2 to lock a value that must stay fixed |
| The numbers are real numbers | Check alignment; text usually sits on the left | Convert the values to numbers, then recalculate |
| The error code makes sense | Read the code: #DIV/0! means division by zero, #VALUE! means a wrong data type, #REF! means a deleted reference, #NAME? means a misspelled function | Fix the cause in the source cell, not the result cell |
| Filled formulas are consistent | Click three or four filled cells and compare them | Retype the formula in the first correct cell and fill it down again |
If you use machine translation or OCR on a document that contains formulas or labels, check the translated text against the original before you share the file.
❓ FAQ
1. Do I need to memorize every Excel function?
No. Learn the handful you use often, such as SUM, AVERAGE and IF, and look up others when a task calls for them. Understanding how a function reads its range and arguments matters more than remembering its name.
2. Why does my cell show the formula text instead of a result?
The cell is usually formatted as text, or the formula was typed after a leading apostrophe. Change the cell format to a number or general format, then retype the formula so the program evaluates it.
3. What is the difference between a formula and a function?
A formula is any expression that starts with an equals sign, such as =B2*C2. A function is a built-in calculation with a name, such as SUM or AVERAGE, that you can place inside a formula.
4. Can I translate an Excel file that contains formulas?
Yes. You can upload an .xlsx file on omnidoc.top and choose bilingual or translation-only output. Translation keeps layout, tables and formulas, but review the translated labels and any text that feeds a calculation before you rely on them.
📝 Summary
Learning excel formulas tutorial with examples works well when you build a small table, write one formula at a time, and check each result by hand. Fill formulas down with cell references, read error codes as clues, and export PDF tables to Excel format before you start.
