Solved: Negative number formula in Excel

Status
This thread has been Locked and is not open to further replies. Please start a New Thread if you're having a similar issue. View our Welcome Guide to learn how to use this site.

Lostinexcel2002

Thread Starter
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.


Thanks in advance
 

WhitPhil

Gone but never forgotten
Trusted 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
 

Lostinexcel2002

Thread Starter
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
 

WhitPhil

Gone but never forgotten
Trusted 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.
 

Lostinexcel2002

Thread Starter
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!
 

Lostinexcel2002

Thread Starter
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!
 

WhitPhil

Gone but never forgotten
Trusted Advisor
Joined
Oct 4, 2000
Messages
8,684
In C3
=IF(A3<B3,A3,A3-B3)

in D3
=IF(A5>B5,A5-B5,0)
 
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.
 
Status
This thread has been Locked and is not open to further replies. Please start a New Thread if you're having a similar issue. View our Welcome Guide to learn how to use this site.

Users Who Are Viewing This Thread (Users: 0, Guests: 1)

As Seen On
As Seen On...

Welcome to Tech Support Guy!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.

Join over 807,865 other people just like you!

Latest posts

Members online

Top