+ Reply to Thread
Results 1 to 4 of 4

Calculate based on cell value but dont show negative results

  1. #1
    Forum Contributor
    Join Date
    04-12-2013
    Location
    Crayford, kent
    MS-Off Ver
    Excel 2013
    Posts
    394

    Calculate based on cell value but dont show negative results

    Hi All

    Im trying to calculate an overpayment based on the value of two cells, so i have my if formula calculating a true value if cell 1 is <0 and a false if cell 1 is >0 but if the formulas calculation returns a negative i need it to show £0 as the result....

    I dont know how to build this in any ideas?

    Dan

    Book1.xlsx

  2. #2
    Forum Expert
    Join Date
    08-12-2012
    Location
    Sydney, Australia
    MS-Off Ver
    Excel 2010
    Posts
    5,636

    Re: Calculate based on cell value but dont show negative results

    Is this what your after?
    Attached Files Attached Files
    If you are satisfied with the solution(s) provided, please mark your thread as Solved.
    Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

  3. #3
    Forum Guru Pete_UK's Avatar
    Join Date
    12-31-2011
    Location
    Warrington, England
    MS-Off Ver
    Office 2019 (still learning)
    Posts
    24,604

    Re: Calculate based on cell value but dont show negative results

    Change the formula in C15 to this:

    Formula: copy to clipboard
    Please Login or Register  to view this content.


    (changes in red), then copy across.

    Hope this helps.

    Pete

  4. #4
    Forum Contributor
    Join Date
    04-12-2013
    Location
    Crayford, kent
    MS-Off Ver
    Excel 2013
    Posts
    394

    Re: Calculate based on cell value but dont show negative results

    Both work brilliantly!! thank you both veyr much

  5. #5
    Forum Guru Pete_UK's Avatar
    Join Date
    12-31-2011
    Location
    Warrington, England
    MS-Off Ver
    Office 2019 (still learning)
    Posts
    24,604

    Re: Calculate based on cell value but dont show negative results

    You're welcome - thanks for the feedback (and the rep).

    Pete

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] How do I calculate and show negative time in Excel?
    By Ramonak in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 09-07-2005, 12:05 AM
  2. How do I calculate and show negative time in Excel?
    By Ramonak in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 09-06-2005, 11:05 PM
  3. How do I calculate and show negative time in Excel?
    By Ramonak in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 09-06-2005, 10:05 PM
  4. How do I calculate and show negative time in Excel?
    By Ramonak in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 09:05 PM
  5. Replies: 6
    Last Post: 08-29-2005, 07:05 PM

Tags for this Thread

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1