How to Do Formulas in Excel: The Complete 2026 Beginner-to-Advanced Guide

Learning how to do formulas in Excel is the single most valuable spreadsheet skill you can build, and the good news is that it starts with one character: the equals sign. Every formula in Excel begins with =, which tells the program that the contents of a cell should be calculated rather than displayed as plain text. Type =5+3 into any cell, press Enter, and Excel returns 8. That tiny moment is the foundation of everything from a household budget to a corporate financial model used across the world.

People search for all kinds of things with the word "excellence" in them—from the excellence playa mujeres resort to the inner excellence book—but the kind of excellence that actually changes your workday is the ability to make Excel do your arithmetic automatically. Instead of reaching for a calculator and typing numbers back into cells, you let the spreadsheet add, subtract, multiply, average, and look up data on its own. When a source number changes, the formula recalculates instantly, which removes the most common source of human error.

This guide walks you through the entire formula journey in plain language. We start with the structure of a formula and the four basic math operators, then move into cell references, which are what make formulas powerful and reusable. From there we cover the most common built-in functions like SUM, AVERAGE, COUNT, IF, and the famous vlookup excel function that pulls matching data from another table. By the end you will understand not just how to type a formula but how to think like a spreadsheet.

We also cover the practical features that surround formulas in everyday work. You will learn how to merge cells in excel for clean headers, how to freeze a row in excel so your column titles stay visible while you scroll, and how to create a drop down list in excel so people enter consistent values that your formulas can rely on. These tools are not formulas themselves, but they make your formula-driven worksheets far easier to read and maintain.

Throughout the article we keep things concrete with real numbers and step-by-step examples. You will see exactly what to type, what Excel returns, and why. We point out the small mistakes that trip up beginners, like forgetting the equals sign, mixing up relative and absolute references, or wrapping text in the wrong kind of quotation marks. Each of these has a simple fix once you know what to look for, and we flag them as we go.

Whether you are a student, an office worker, a small-business owner, or someone preparing for a certification or job interview, mastering formulas pays off immediately. Excel runs on hundreds of millions of computers, and the formula syntax you learn here is nearly identical in Google Sheets and LibreOffice Calc, so the knowledge transfers. Let's begin with the anatomy of a formula and build your confidence one calculation at a time, starting from absolute zero and ending with lookup functions.

Once you can type a basic formula, the next concept to master is the cell reference, because references are what turn a one-off calculation into a flexible, reusable tool. A cell reference is simply the address of a cell, written as a column letter followed by a row number, such as A1, C5, or AB200. When you write =A1+A2, you are telling Excel to add whatever happens to be in those two cells right now, and to recalculate the moment either value changes. This is the heart of why spreadsheets are so powerful.

References come in three flavors, and understanding the difference saves hours of frustration. A relative reference like A1 changes when you copy the formula to another cell. If you copy =A1+B1 from row 1 down to row 2, it automatically becomes =A2+B2. That behavior is usually exactly what you want when totaling a column. Excel shifts the references in step with the formula's new location, so one formula can serve an entire table after a single drag of the fill handle.

An absolute reference uses dollar signs, like $A$1, to lock both the column and the row so they never change when copied. This matters when you have a single fixed value—say a tax rate in cell B1—that many rows need to reference. Writing =A2*$B$1 lets you copy the formula down while every row keeps pointing at the same tax-rate cell. Press the F4 key while editing a reference to cycle through the dollar-sign combinations quickly instead of typing them by hand.

The third flavor is the mixed reference, which locks only the row or only the column, such as A$1 or $A1. These are useful in multiplication tables and grid-style layouts where you need one coordinate to stay put while the other moves. Beginners can ignore mixed references at first, but they become valuable as your models grow more sophisticated and you start building two-dimensional calculation grids that reference both a header row and a left-hand column.

You can also reference a range of cells, which is a block written with a colon, like A1:A10 for ten cells in a column or A1:D4 for a rectangle. Most functions accept ranges, so =SUM(A1:A10) adds all ten cells at once. You select a range by clicking the first cell and dragging to the last, or by typing the addresses directly. Ranges keep formulas short and readable instead of forcing you to list every cell individually with plus signs.

Finally, formulas can reach across worksheets and even workbooks. To reference a cell on another sheet, you write the sheet name, an exclamation point, and the cell address, such as =Sheet2!A1. This lets you keep raw data on one tab and summaries on another, a tidy practice that scales well. As your files grow, clear references and consistent layout become just as important as the formulas themselves, because they make your work auditable by you and by anyone who inherits the file.

With references understood, let's put the most common functions to work, because functions are pre-built formulas that handle tasks you would otherwise do by hand. A function has a name and a set of arguments inside parentheses. The workhorse is SUM, written as =SUM(A1:A10), which adds every number in the range. It is faster and far less error-prone than typing =A1+A2+A3 and so on, and it automatically includes any cells you later insert inside the range if you extend it.

AVERAGE works the same way, returning the arithmetic mean of a range with =AVERAGE(B2:B20). COUNT tallies how many cells contain numbers, while COUNTA counts non-empty cells of any type, including text. These three functions answer the most common questions any dataset raises: what is the total, what is the typical value, and how many entries do I actually have? Together they form the statistical backbone of nearly every basic report you will ever build in a spreadsheet.

The MAX and MIN functions return the largest and smallest values in a range, which is handy for spotting the top sale or the cheapest supplier. For example, =MAX(C2:C50) instantly finds your highest figure without sorting the column. You can combine these with other functions, and you will quickly discover that Excel lets you nest functions inside one another, feeding the output of one directly into the input of the next for compact, powerful calculations.

The IF function introduces decision-making, and it is the gateway to logical formulas. Its structure is =IF(condition, value_if_true, value_if_false). A formula like =IF(A2>=60, "Pass", "Fail") checks whether a score reaches sixty and writes Pass or Fail accordingly. You can chain conditions with nested IFs or combine them with AND and OR, such as =IF(AND(A2>=60, B2="Yes"), "Approved", "Review"), giving your spreadsheet the ability to apply business rules automatically across thousands of rows.

Closely related are the conditional aggregation functions SUMIF, COUNTIF, and AVERAGEIF, which calculate only the cells that meet a criterion. =SUMIF(A2:A100, "East", B2:B100) adds the sales figures in column B only for rows where column A says East. These functions are enormously useful for regional summaries, category totals, and dashboards. Their plural cousins—SUMIFS, COUNTIFS, and AVERAGEIFS—let you apply several criteria at once, such as East region and the month of March together.

Text functions round out the everyday toolkit. CONCAT or the ampersand operator joins text, so =A2&" "&B2 combines a first and last name with a space between them. LEFT, RIGHT, and MID extract characters from a string, while TRIM removes stray spaces that break lookups, and UPPER, LOWER, and PROPER fix capitalization. LEN counts characters in a cell. Mastering even a handful of these functions transforms Excel from a glorified table into a genuine calculation engine that does real work for you.

Formulas rarely live alone; they sit inside worksheets that need to be readable, navigable, and protected against bad input. Three formatting features come up constantly alongside formulas, and learning them makes your work look professional and behave predictably. The first is how to merge cells in excel, which combines two or more adjacent cells into one larger cell. Select the cells, go to the Home tab, and click Merge & Center. This is perfect for centering a title across the top of a report or labeling a group of columns under one heading.

Be cautious, though, because merged cells can interfere with sorting, filtering, and some formulas. A common professional alternative is "Center Across Selection," found in the Format Cells dialog under the Alignment tab, which gives the centered look without actually merging the cells. If you do merge, keep merged cells out of ranges that formulas calculate, since a merged block stores its value only in the top-left cell and leaves the others technically empty, which can confuse SUM and COUNT.

The second essential feature is how to freeze a row in excel, which keeps your header row visible while you scroll through hundreds of rows of data. Go to the View tab, click Freeze Panes, and choose Freeze Top Row. To freeze the first column instead, choose Freeze First Column. For both at once, select the cell just below and to the right of the area you want locked, then click Freeze Panes. Frozen headers prevent the all-too-common mistake of misreading which column a number belongs to deep in a long sheet.

The third feature is how to create a drop down list in excel, which controls what people can type into a cell and keeps your data clean for formulas. Select the target cells, open the Data tab, and click Data Validation. Under Allow, choose List, then either type your options separated by commas or point to a range of cells that holds the valid choices. Now each cell shows a little arrow, and users pick from your approved values instead of typing inconsistent variations like "East," "east," and "Eastern."

Drop-down lists pair beautifully with lookup and conditional functions. If a user selects a region from a drop-down, a SUMIF or VLOOKUP elsewhere can instantly recalculate based on that choice, effectively turning a static sheet into a simple interactive dashboard. Because the input is constrained to known values, your formulas never break on a typo, and your COUNTIF criteria always match. This combination of validated input and responsive formulas is the foundation of countless business templates.

Finally, remember that number formatting changes how a result looks without changing the underlying value. A cell containing 0.08 can display as 8% or $0.08 depending on the format you apply, yet formulas still calculate with the true 0.08. Use the Number group on the Home tab to apply currency, percentage, date, and comma styles. Clean formatting, frozen headers, sensible merges, and validated drop-downs together make formula-driven worksheets that are not only correct but genuinely pleasant to use and easy to maintain over time.

Now that you understand the components, let's pull everything together with practical advice that will accelerate your progress and help you avoid the habits that slow beginners down. The fastest way to learn how to do formulas in excel is to build a real project you care about, such as a monthly budget, a grade tracker, or a small inventory list. Working with data that matters to you keeps you motivated and forces you to solve genuine problems rather than memorizing isolated examples that you forget within a week.

Use the function library as a learning tool. When you click the small fx button beside the formula bar, Excel opens the Insert Function dialog, which lets you search for a function by description and walks you through each argument with plain-language prompts. As you type a function name directly into a cell, Excel also shows a tooltip listing the arguments in order, bolding the one you are currently entering. Lean on these aids constantly; even experienced analysts use them rather than memorizing every argument sequence.

Learn to read error messages instead of fearing them, because each one tells you exactly what went wrong. #DIV/0! means you divided by zero or an empty cell. #VALUE! means a formula expected a number but found text. #REF! means a referenced cell was deleted. #NAME? usually means a function name is misspelled or text is missing its quotation marks. #N/A appears when a lookup finds no match. Treat these as helpful diagnostics, and fix the root cause rather than hiding the symptom.

Build formulas incrementally for complex tasks. Rather than writing one giant nested formula and hoping it works, calculate each step in its own column first, confirm the numbers are right, and only then combine the pieces. This staged approach makes debugging trivial because you can see exactly where the logic breaks. Once the combined formula works, you can hide or delete the helper columns, but during construction they are invaluable for catching mistakes early before they compound.

Get comfortable with keyboard efficiency. Double-clicking the fill handle copies a formula down to match the length of the adjacent column automatically, saving you from dragging across a thousand rows. Pressing Ctrl plus the grave accent toggles a view that shows all formulas instead of their results, which is perfect for auditing a sheet. Selecting a cell and pressing F2 lets you edit in place and see colored outlines around every referenced cell, making relationships visible at a glance.

Finally, practice deliberately and test yourself. Reading about formulas builds familiarity, but typing them builds skill, and answering quiz questions builds confidence under pressure. Recreate examples from this guide, then change the numbers and predict the results before pressing Enter. Try breaking a formula on purpose to see which error appears. Over a few focused sessions, the equals sign, cell references, and core functions will become second nature, and you will reach for Excel automatically whenever numbers need organizing or calculating.