Calculation Issues

How to Add and Subtract Numbers in One Excel Cell

John WilsonJohn Wilson Nov 18, 2026 869 views

Question details

Calculate a series of additions and subtractions entered in a single Excel cell.

How to Add and Subtract Numbers in One Excel Cell
Product
Microsoft Excel
Device & OS
not provided
Scenario
The user wants to enter an expression such as 1+2+3-4+4 in one cell and display its total.
Observed behavior
The cell should display 6 after Excel evaluates the expression as a formula.
Before you start

Select the cell where you want the result and check that its number format is General rather than Text. In Excel, you can change the format from the Home tab's Number Format menu.

Solution 1Recommended

Enter the expression as an Excel formula

Use a leading equal sign or plus sign so Excel calculates the numbers instead of treating the expression as text.

1
Select a cell

Click the cell where you want to display the total.

2
Enter the formula

Type =1+2+3-4+4 in the cell. You can also start with a plus sign: +1+2+3-4+4.

3
Calculate the total

Press Enter. The cell displays 6; select it to see the formula in the formula bar.

Enter the expression as an Excel formula
If the formula appears as text: Change the cell's number format to General on the Home tab, then edit the cell and press Enter again.
Calculate in WPS Spreadsheets

Add and subtract in one cell with WPS Spreadsheets

Enter an arithmetic expression as a formula in WPS Spreadsheets to display the total in the same cell.

  1. 1. Open a spreadsheet: Open WPS Spreadsheets and create or open a workbook.
  2. 2. Select a cell: Click the cell where you want the total.
  3. 3. Enter the expression: Type =1+2+3-4+4 in the selected cell.
  4. 4. Display the result: Press Enter to calculate the formula and display 6.
Calculate additions and subtractions in a single cellOpen and edit Microsoft Excel XLSX and XLS filesUse a familiar spreadsheet interfaceWork with formulas in the free WPS Office suite
microsoft office alternative - wps office

Frequently Asked Questions

Why does Excel display my expression instead of calculating it?

The entry may lack a leading equal or plus sign, or the cell may be formatted as Text. Choose General from Home > Number Format, then edit the entry to begin with = and press Enter.

Can I start an Excel formula with a plus sign?

Yes. Entering +1+2+3-4+4 and pressing Enter calculates the expression. You can also use the standard equal-sign form, =1+2+3-4+4.

How can I see the formula after Excel displays the total?

Select the result cell and look at the formula bar above the worksheet.

Can WPS Spreadsheets calculate the same expression?

Yes. Select a cell in WPS Spreadsheets, enter =1+2+3-4+4, and press Enter to display 6.