To calculate numbers in Excel, start a cell entry with an equals sign and use cell references or values with an arithmetic operator. For example, if A2 contains 18 and B2 contains 7, enter =A2+B2 in another cell and press Enter to get 25. Use the same approach for subtraction, multiplication, and division, or use functions such as SUM for totals. The steps below show how to build, copy, and check common calculations in Excel for Microsoft 365 on Windows.
What You’ll Need
- Excel for Microsoft 365 on Windows, with a blank or existing workbook open. The core instructions also work in recent desktop versions of Excel.
- Numbers entered into worksheet cells, ideally with a clear heading for each column. Use one cell per value rather than typing an entire calculation into a single data cell.
- A destination cell for the result. Save a copy of an important workbook before making broad changes, especially if it contains formulas you did not create.
Step-by-Step
- Enter and check your numbers. Put each value in its own cell, and add labels such as Price, Quantity, or Total in the row above. For example, you could enter 18 in A2 and 7 in B2. Select a cell and look at the formula bar to confirm the value Excel has stored. A number aligned left, or one with a green warning marker, may be stored as text; that can prevent it from behaving like a number. Avoid including units such as dollars or the word items in the same cell as the value. You can apply a number format later while keeping the underlying value numeric.
- Choose the result cell and start a formula. Click an empty cell where you want the answer, type an equals sign, then enter the calculation. Excel treats an entry beginning with = as a formula and displays the result after you press Enter. With 18 in A2 and 7 in B2, enter
=A2+B2in C2; the result is 25. Referring to cells instead of typing 18 and 7 directly makes the answer update if either input changes. You can also click cells while building a formula: type =, click A2, type +, click B2, then press Enter. - Use the operator that matches the calculation. For a simple example, assume A2 contains 18 and B2 contains 7. To subtract B2 from A2, enter
=A2-B2in C2; the result is 11. To multiply the two cells, enter=A2*B2in C2; the result is 126. To divide A2 by B2, enter=A2/B2in C2; the result is approximately 2.5714, depending on the cell’s number format. Excel uses an asterisk for multiplication and a forward slash for division. The plus sign adds, and the minus sign subtracts. - Combine operations carefully. Excel follows standard order of operations: multiplication and division are evaluated before addition and subtraction. Use parentheses when you need to control the order. With A2 equal to 18, B2 equal to 7, and C2 equal to 3, enter
=A2+B2*C2in D2 to get 39, because 7 times 3 is calculated first. With those same values, enter=(A2+B2)*C2in D2 to get 75, because the parentheses make Excel add 18 and 7 first. Check parentheses in pairs if Excel reports a formula error. - Calculate a total with SUM. For a list of values, a function is easier to maintain than adding every cell with plus signs. Suppose A2:A6 contains 12, 8, 15, 5, and 10. Enter
=SUM(A2:A6)in A7 to get 50. The colon means the range includes every cell from A2 through A6. You can type the range or drag across it after typing the opening parenthesis. When the data is in a continuous column, check that the selected range includes all intended rows and excludes headings or unrelated values. If you add more entries later, update the range or place the list in an Excel table so it is easier to extend consistently. - Find an average or count numeric entries. If A2:A6 contains 12, 8, 15, 5, and 10, enter
=AVERAGE(A2:A6)in A7 to return 10. AVERAGE uses the numeric values in the range and ignores blank cells and text. To count numbers rather than add them, assume A2:A6 contains 12, the text pending, a blank, 8, and 15; enter=COUNT(A2:A6)in A7 to return 3. If you want to count all nonempty cells, including the text entry, use=COUNTA(A2:A6)in A8; it returns 4 for that layout. COUNT and COUNTA answer different questions, so choose based on whether you mean numeric values or occupied cells. - Calculate a percentage or a percentage of a value. Excel stores percentages as decimal values, so 15% is equivalent to 0.15. If A2 contains a base amount of 250, enter
=A2*15%in B2 to calculate 15% of it; the result is 37.5. If A2 contains 250 and B2 contains 37.5, enter=B2/A2in C2 to find what share B2 is of A2; the result is 0.15. Select C2 and choose Percentage in the Home tab’s Number group to display 15%. Formatting changes how the answer appears, not the underlying calculation. If you type 15 rather than 15%, Excel interprets it as 15, or 1,500% when displayed as a percentage. - Copy the formula and format the result. When a calculation should repeat down a column, select its formula cell and drag the small square at its lower-right corner, called the fill handle, down over the destination cells. Excel normally adjusts relative references as it copies: a formula using A2 and B2 in row 2 changes to A3 and B3 in row 3. Review a few copied results to confirm each row points to the intended inputs. To make results easier to read, select them and use the number-format options in Home > Number, such as Number, Currency, or Percentage. Increase decimal places only when the extra precision is useful; the stored calculation remains more precise than a rounded display.
Common Mistakes
Leaving out the equals sign: Without = at the beginning, Excel may treat what you typed as text rather than calculate it. Edit the cell, add the equals sign, and press Enter.
Using the wrong operator: Multiplication needs an asterisk, not the letter x, and division uses a slash. Check each operator if the result looks unexpectedly large or small.
Including text in a calculation: Numbers imported from websites or reports can be stored as text, especially if they contain leading apostrophes, spaces, or inconsistent separators. Convert the cells to numbers rather than assuming Excel will calculate them as intended.
Selecting an incomplete range: A total can look plausible while missing the last few rows. Inspect the range shown between parentheses and compare it with the first and last data rows.
Confusing display with value: A cell showing 10 may contain 10.234 rounded for display. Changing decimal places can reveal the stored precision; it does not alter the underlying formula.
Overwriting a formula: Typing a value into a result cell replaces its formula. If a result stops updating, select it and check the formula bar before re-entering the calculation.
Tips
Use cell references for inputs that might change, and keep source values separate from calculated results. This makes the worksheet easier to audit and reduces the chance of changing a number in one place but forgetting to update a hard-coded formula elsewhere.
Give columns clear headers and keep each column consistent: for example, store quantities together and prices together. Avoid blank rows within a list that you plan to total, because blank cells can make it harder to spot missing entries even when SUM handles them without an error.
When a formula is complex, build it in small pieces and verify each intermediate result. Parentheses make the intended order clearer to another person, even when Excel’s default order would produce the same result. Use descriptive labels near important outputs so readers know whether a figure is a total, difference, or percentage.
In Windows Excel, Ctrl+Z undoes many recent edits, including an accidental overwrite, but it may not restore a change after the workbook has been closed or the undo history is lost. On Mac, use Command+Z for Undo. Excel for the web has the same basic formula syntax; some ribbon locations and keyboard shortcuts can differ slightly from the Windows desktop app.
Troubleshooting
The cell displays the formula instead of its answer. The cell may be formatted as Text, or Show Formulas may be enabled. Change the cell’s format to General using Home > Number, edit the formula, and press Enter. If formulas appear throughout the sheet, check the Formulas tab for Show Formulas and turn it off. In Windows, Ctrl+` toggles formula display; the key is usually beside 1, though keyboard layouts vary.
The result is a row of pound signs (####). This usually means the column is too narrow to show the formatted value, rather than that the calculation failed. Widen the column by dragging its right boundary, or double-click that boundary to fit the contents. If the value is a date or time, also check that the number format is appropriate.
Excel shows #DIV/0!. The formula is dividing by zero or by an empty cell being used as the divisor. Check the cell reference after the slash and confirm the denominator contains a nonzero number. If zero is a legitimate possibility, decide how the worksheet should display that situation instead of hiding an error without explanation.
The answer does not change after an input changes. Confirm that the result cell still contains a formula and refers to the cell you edited. If the workbook is set to manual calculation, choose Formulas > Calculation Options > Automatic. Then press Enter in the edited cell or recalculate the workbook. If only some rows fail to update, inspect copied formulas for incorrect references.
The total is too small or too large. Check for text-formatted numbers, omitted cells, duplicated entries, and the formula’s range. Select a suspicious input and look at the formula bar; if it has an apostrophe before the value or behaves like text, convert it to a number. For financial or measurement data, also verify that all entries use the same units.
Frequently Asked Questions
How do I add numbers in Excel? Enter a formula in an empty cell using plus signs between values or references. For a list, SUM is usually clearer and easier to extend. Verify that the chosen cells cover the full list.
How do I multiply two cells? Use an asterisk between the references. With the values in A2 and B2, enter =A2*B2 in another cell. Excel returns their product and updates it when either input changes.
Can Excel calculate without formulas? Yes. Select numeric cells and look at the status bar at the bottom of the Excel window, which can show quick calculations such as Sum, Average, and Count. This is useful for a quick check, but it does not place a result in a worksheet cell. Right-click the status bar to choose which calculations appear.
Why does Excel show a decimal instead of a percentage? A percentage calculation is often stored as a decimal, such as 0.15. Select the result and choose Percentage in Home > Number to display it as 15%. The format changes the display, not the value.
How can I calculate the same thing for every row? Enter the formula in the first result row, then use the fill handle to copy it down. Check that the references shift to the matching row. If a reference must stay fixed when copied, Excel supports absolute references with dollar signs; use them only for cells that should not move.
Does this work in Excel for Mac or the web? Basic formulas, operators, and functions such as SUM, AVERAGE, COUNT, and COUNTA work in Excel for Mac and Excel for the web. Ribbon placement and shortcuts can vary, so use the app’s tabs and command search if a Windows path differs.
Related
- Add Color to Excel Data Validation Lists
- How to Add Color to Every Other Row in Excel Easily
- How to Add a Black Border in Excel to Cells and Tables
Try it: the Formula Explainer: paste any formula and see each function and reference in plain English.
More in Formulas & functions
- Find the Average in Excel with the AVERAGE FunctionTo find the average in Excel, enter =AVERAGE(B2:B6) in an empty cell and press Enter, replacing B2:B6 with…
- Excel INDEX Function: Syntax, Examples, and Common UsesYes. In the English-language version of Microsoft Excel, the function is called INDEX. It returns the value—or, in…
- How to Concatenate a New Line in Excel with a FormulaTo join text from two Excel cells with a line break between them, enter =A2&CHAR(10)&B2 in a third…
- Excel Filter for Duplicate Values: Find and Review ThemTo filter duplicate values in Excel for Microsoft 365 on Windows, add a helper column with =COUNTIF($A$2:$A$100,A2)>1, fill…
- Excel Split Cells With Regex: Formulas and MethodsYes—Excel for Microsoft 365 can split text using a regular expression by replacing regex-matched separators with a marker…
- Excel LEN Formula Examples: Count Text in CellsIn Excel for Microsoft 365, use =LEN(A2) to count the characters in cell A2, including spaces and punctuation.…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.