+ Reply to Thread
Results 1 to 3 of 3

Thread: Negative Number as a Zero

  1. 11-03-2009, 03:01 PM #1
    garybarrow
    garybarrow is offline
    Registered User
    Join Date
    10-27-2009
    Location
    Sierra Vista AZ
    MS-Off Ver
    Excel 2007
    Posts
    9

    Question Negative Number as a Zero

    My Formula is =(J42-K43)+H45

    If J42-K43 equals a negative number, I want it to be zero; then add H45. Any help? Formatting the cell will not work, if J42-K43 is a negative number, I need it to be a value of zero (and then add cell H45) not just displayed as such. Any help???
    Last edited by garybarrow; 11-03-2009 at 03:17 PM.
    Reply With Quote Reply With Quote
  2. 11-03-2009, 03:06 PM #2
    shg
    shg is offline
    Forum Guru shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2007, 2010
    Posts
    25,777

    Re: Negative Number as a Zero

    =max(0, J42-K43) + H45
    Microsoft MVP - Excel
    Entia non sunt multiplicanda sine necessitate
    Reply With Quote Reply With Quote
  3. 11-03-2009, 03:22 PM #3
    garybarrow
    garybarrow is offline
    Registered User
    Join Date
    10-27-2009
    Location
    Sierra Vista AZ
    MS-Off Ver
    Excel 2007
    Posts
    9

    Re: Negative Number as a Zero

    GREAT!! Just what I needed! How do I rate you for helping me? I've tried to find it in the FAQ but failed....
    Reply With Quote Reply With Quote
+ 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)

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.2.0