+ Reply to Thread
Results 1 to 4 of 4

Extend IF formula to return a 'Zero' when result is negative

  1. 02-01-2024, 09:30 AM #1
    EvansB
    EvansB is offline
    Registered User
    Join Date
    09-14-2020
    Location
    London
    MS-Off Ver
    Office 365 Enterprise
    Posts
    88

    Extend IF formula to return a 'Zero' when result is negative

    Hi there,

    In the attached working example, cell B4 compares the outcomes in cells B2 & B3 as per the formula. I would like cell B4 to return a Zero amount in the case a negative number is returned. It would act as a default as I can't have a negative number.

    Any help would be appreciated.

    Ben
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 02-01-2024, 09:32 AM #2
    AliGW
    AliGW is online now
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    80,916

    Re: Extend IF formula to return a 'Zero' when result is negative

    Try this:

    =MAX(0,IF(B2<B3,B2,B3))
    Ali

    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
    Forum Rules (updated August 2023): please read them here.
    Reply With QuoteRegister To Reply
  3. 02-01-2024, 09:34 AM #3
    DJunqueira
    DJunqueira is offline
    Forum Expert
    Join Date
    10-19-2021
    Location
    Brazil
    MS-Off Ver
    Office 365 V2401 w/ Win10 Home 64 Bit
    Posts
    2,014

    Re: Extend IF formula to return a 'Zero' when result is negative

    Try this.
    Formula: copy to clipboard 
    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
  4. 02-01-2024, 10:59 AM #4
    ByteMarks
    ByteMarks is offline
    Forum Expert
    Join Date
    07-23-2018
    Location
    UK
    MS-Off Ver
    O365 32bit (Windows)
    Posts
    1,980

    Re: Extend IF formula to return a 'Zero' when result is negative

    Or this

    Formula: copy to clipboard 
    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Want IF statement to produce 0 if the formula result is negative
    By ExcelNoobie1 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 09-12-2019, 10:52 AM
  2. [SOLVED] If the result of the formula is less than 0 I need it to display 0 instead of a negative #
    By GatorsBucs in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 02-01-2018, 10:08 AM
  3. Networkdays formula producing negative result
    By jeni2015 in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 05-01-2015, 03:45 PM
  4. [SOLVED] Networkdays formula - negative result
    By Lukael in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 02-27-2014, 03:47 PM
  5. If the result of a formula is a negative number, I want it to put 0
    By AnnaV in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 01-06-2009, 04:29 PM
  6. If the result of a formula is negative make equal to zero
    By Nrippe in forum Excel - New Users/Basics
    Replies: 5
    Last Post: 06-12-2006, 05:45 PM
  7. Advanced formula - Return result & Show Cell Reference of result
    By Irv in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 05-05-2006, 10:40 PM

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1