# How to Use Negative Numbers to Calculate in Excel

Written by kate bluest
• Share
• Tweet
• Share
• Pin
• Email

Microsoft Excel spreadsheets can handle inventory: what you have, what you had, what you sold and what you have left. You can input figures into a Microsoft Excel spreadsheet and subtract a number from what you originally had in inventory to determine what's left. You can use negative numbers to show the difference; for example with "15 - 10," this equation is actually "15 + (-10)."

You can format the way negative numbers appear in your spreadsheet. Numbers can be formatted with a negative sign, with double parentheses, or by using the colour red.

Skill level:
Easy

## Instructions

1. 1

Enter a negative number into an Excel spreadsheet cell by using the minus sign (-) before the number.

"-12" is an example of a negative number.

2. 2

Use the arithmetic operator, the minus sign (-), to subtract a number using a formula.

An example is the formula, "=25-10" that will give a result of "15."

3. 3

Use a function to calculate negative and positive numbers.

An example of this is "=sum(a1:a3)", where cell a1=10, cell a2=12 and cell a3=-25 will give a result of "-3."

4. 4

Use a function to transform a positive result into a negative result by applying the negative sign (-) to the function. An example of this is "=-sum(a1:a3)" using the established values for those cells will give a result of "3."

1. 1

Select a number or range of numbers to change the way Excel displays these numbers.

2. 2

Click the "Home" tab on the top menu and select the arrow in the "Number" section.

3. 3

Choose either the "Number" or the "Currency" category in the "Category:" list in the "Format Cells" window.

4. 4

Select the number of decimal places by either typing it in or selecting the up or down arrow in the "Format Cells" window.

5. 5

Choose the "Use 1000 Separator (,)" check box. Skip this if you are formatting currency.

6. 6

Choose the currency symbol by clicking the down arrow in the box next to "Symbol." Skip this if you are not formatting currency.

7. 7

Select the number format in the "Negative numbers:" box in the "Format Cells" window.

8. 8

Click the "OK" button.

#### Tips and warnings

• Negative times will be displayed as number symbols (####). You can adjust the way the number is displayed by using the TEXT function.

### Don't Miss

#### Resources

• All types
• Articles
• Slideshows
• Videos
##### Sort:
• Most relevant
• Most popular
• Most recent