1. Computer problem? Tech Support Guy is completely free -- paid for by advertisers and donations. Click here to join today! If you're new to Tech Support Guy, we highly recommend that you visit our Guide for New Members.

Solved: Negative number formula in Excel

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

Thread Status:
Not open for further replies.
Advertisement
  1. Lostinexcel2002

    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
     
  2. WhitPhil

    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
     
  3. Lostinexcel2002

    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
     
  4. WhitPhil

    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.
     
  5. Lostinexcel2002

    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!
     
  6. Lostinexcel2002

    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!
     
  7. WhitPhil

    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)
     
  8. slurpee55

    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.
     
  9. Sponsor

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 733,556 other people just like you!

Loading...
Similar Threads - Solved Negative number
  1. ImaGrump
    Replies:
    5
    Views:
    699
  2. floydcojacket
    Replies:
    3
    Views:
    368
Thread Status:
Not open for further replies.

Short URL to this thread: https://techguy.org/701113

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice