How to Add and Subtract Numbers in One Excel Cell
Question details
Calculate a series of additions and subtractions entered in a single 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.
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.
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.
Click the cell where you want to display the total.
Type =1+2+3-4+4 in the cell. You can also start with a plus sign: +1+2+3-4+4.
Press Enter. The cell displays 6; select it to see the formula in the formula bar.

Convert an existing expression into a formula
Use this method when the expression has already been entered without a leading formula sign.
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. Open a spreadsheet: Open WPS Spreadsheets and create or open a workbook.
- 2. Select a cell: Click the cell where you want the total.
- 3. Enter the expression: Type =1+2+3-4+4 in the selected cell.
- 4. Display the result: Press Enter to calculate the formula and display 6.

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.




