# Subtraction

This is a discussion on Subtraction within the Excel Questions forums, part of the Question Forums category; I would like to subtract the following numbers. 54139 30682 71804 71804-(54139+30682) in that order. I should get a negative ...

1. ## Subtraction

I would like to subtract the following numbers.
54139 30682 71804

71804-(54139+30682) in that order. I should get a negative number but all I get is this result #VALUE!

Help

2. ## Re: Subtraction

Originally Posted by Deb Mitchell
I would like to subtract the following numbers.
54139 30682 71804

71804-(54139+30682) in that order. I should get a negative number but all I get is this result #VALUE!

Help
I got -13017

=71804-(54139+30682)

Are they in different cells? What cells are they in? You may have formatted one as text.

3. ## Re: Subtraction

Test whether each cell gives TRUE when you apply...

=ISNUMBER(cell)

4. ## Re: Subtraction

Are you trying to type it into one Excel cell? If so, you need an equal sign:
=71804-(54139+30682)

5. ## Re: Subtraction

I got it. I was formating it =D3-(B3:C3). I changed the ":" to a "+" and it works. =D3-(B3+C3).

Thanks!

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•