Solved: Negative number formula in Excel

[Lostinexcel2002]

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.


Thanks in advance

 

[WhitPhil]

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

 

[Lostinexcel2002]

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

 

[WhitPhil]

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.

 

[Lostinexcel2002]

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!

 

[Lostinexcel2002]

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!

 

[WhitPhil]

In C3
=IF(A3<B3,A3,A3-B3)

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

 

[slurpee55]

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.