+ Reply to Thread
Results 1 to 2 of 2

Index and Match to make negative numbers zero

  1. #1
    Forum Contributor
    Join Date
    08-23-2013
    Location
    Alberta, Canada
    MS-Off Ver
    Excel 365
    Posts
    166

    Index and Match to make negative numbers zero

    Using this Index Match to retrieve numbers from a raw sheet, any way I can have incoming numbers that are negative, to become zeros?

    =IF($G3>Key!$C$10," ",(IF($G3<Key!$C$19,(INDEX(page!$1:$1048576,MATCH($G3,page!$A:$A,0),MATCH($M$1,page!$1:$1,0))),(INDEX(page!$1:$1048576,MATCH($G3,page!$A:$A,0),MATCH($M$69,page!$1:$1,0))))))

  2. #2
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678

    Re: Index and Match to make negative numbers zero

    =max(allThat, 0)
    Entia non sunt multiplicanda sine necessitate

+ 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] Index Match but only return value if cell to right and above 1 is a negative.
    By DaveBre in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 04-07-2014, 03:23 AM
  2. Replies: 7
    Last Post: 05-12-2012, 12:56 PM
  3. Make negative numbers red
    By fernandosaez in forum Excel General
    Replies: 6
    Last Post: 01-26-2011, 04:08 PM
  4. Replies: 5
    Last Post: 05-12-2009, 04:47 PM
  5. [SOLVED] How to make negative numbers look like 0
    By Trisha V via OfficeKB.com in forum Excel General
    Replies: 12
    Last Post: 08-05-2005, 02:12 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