# Solved: Negative number formula in Excel

Discussion in 'Business Applications' started by Lostinexcel2002, Apr 6, 2008.

Not open for further replies.

Joined:
Aug 26, 2007
Messages:
11
Hello,
I was wondering if anyone would know a formula if for example:

\$3000.00 - \$5000.00 = \$3000.00 as any negative answer would equal to the lower numerator.

2. ### WhitPhilGone but never forgottenTrusted Advisor

Joined:
Oct 4, 2000
Messages:
8,684
Cell A=3000
Cell B=5000
Cell C = Cell A-Cell B = (2000)

Now, I presume when Cell C is negative you want to do something, but what?

Also, you use the term Numerator. That, to me, is the number on the top of a fraction. (numberator/denominator). What are you referring to?

Tx

Joined:
Aug 26, 2007
Messages:
11
Hello,
I'm sorry, I didnt mean to use numerator. What I need is continuing from your illustration,

Cell A=3000
Cell B=5000
Cell C = Cell A-Cell B = (2000).....I really want Cell C to equal back to 3000. I am trying to find a formula where I would say I have a car with damages in the amount of \$3000 dollars but I owe the bank \$5000 therefore the insurance company will only pay \$3000

As far as having the formula show that I would get \$0.00 I would use =(MAX(0,A1-B1)) but I need a formula to have the equation back to the lower number.

I hope I have made it clear this time

Thanks

4. ### WhitPhilGone but never forgottenTrusted Advisor

Joined:
Oct 4, 2000
Messages:
8,684
Eg:
A3=3000
B3=5000
then in cell C3
=IF(A3<B3,A3,A3-B3)

will result in 3000 and if A3 contained 6000, then C3 would be 1000.

Joined:
Aug 26, 2007
Messages:
11
Awesome! Thanks for your help......here is the continuation, I hope I can explain this:

2 situations

A3=3000
B3=5000
THEN IN CELL C3=3000 AND D3=0

BUT,

A3=6000
B3=5000
THEN I WANT C3=0 WHICH WILL HAVE D3=1000

IN OTHER WORDS, TOTAL LOSS OF VEHICLE EQUALS 6000, TOTAL OF LIENS EQUAL 5000, WHICH WOULD NOW HAVE ALL PAYMENTS GO TO THE CUSTOMER IN D3=1000 AND NONE TO THE LIEN HOLDER C3

AGAIN, THANKS FOR YOUR HELP AND I PROMISE THIS IS ALL I NEED!

Joined:
Aug 26, 2007
Messages:
11
Awesome! Thanks for your help......here is the continuation, I hope I can explain this:

2 situations

A3=3000
B3=5000
THEN IN CELL C3=3000 AND D3=0

BUT,

A3=6000
B3=5000
THEN I WANT C3=0 WHICH WILL HAVE D3=1000

IN OTHER WORDS, TOTAL LOSS OF VEHICLE EQUALS 6000, TOTAL OF LIENS EQUAL 5000, WHICH WOULD NOW HAVE ALL PAYMENTS GO TO THE CUSTOMER IN D3=1000 AND NONE TO THE LIEN HOLDER C3

AGAIN, THANKS FOR YOUR HELP AND I PROMISE THIS IS ALL I NEED!

7. ### WhitPhilGone but never forgottenTrusted Advisor

Joined:
Oct 4, 2000
Messages:
8,684
In C3
=IF(A3<B3,A3,A3-B3)

in D3
=IF(A5>B5,A5-B5,0)

8. ### slurpee55

Joined:
Oct 20, 2004
Messages:
7,837
Hi Lost, and welcome to the Forum!
As far as I can tell, Phil has answered your question, so please use the thread tools at the top of the page to mark this thread as solved.

As Seen On