+ Reply to Thread
Results 1 to 4 of 4

MIN for different columns of same values produce different results

  1. #1
    Registered User
    Join Date
    01-29-2007
    Location
    Dobson, NC
    MS-Off Ver
    2000
    Posts
    24

    MIN for different columns of same values produce different results

    I do not understand why results are not equal for two different columns with same values. Maybe someone can enlighten me of something I'm not aware of.

    Example:
    1st column is made up of cells with =IF(AND($E9="x",G9>=1),G9," ")
    2nd column is made up of cells with =IF($A9=TRUE,$G9,0)

    The resulting values for both columns are the same for G9.
    MIN(Range) of the 1st produces a number.
    MIN(Range) of the 2nd produces " ". I copied and "pasted special" values in to remove the formulas and still get " "

    Any suggestions please?

    Bob

  2. #2
    Forum Expert daddylonglegs's Avatar
    Join Date
    01-14-2006
    Location
    England
    MS-Off Ver
    Microsoft 365
    Posts
    14,677

    Re: MIN for different columns of same values produce different results

    MIN can never give you a result like " " - it always produces a number (or an error) - if the range doesn't contain any numbers then the result is zero.

    Are you sure you don't have zero (or some other value) returned by the second formula but have the cell in question formatted to show a blank?
    Audere est facere

  3. #3
    Registered User
    Join Date
    01-29-2007
    Location
    Dobson, NC
    MS-Off Ver
    2000
    Posts
    24

    Re: MIN for different columns of same values produce different results

    I have the zero values turned off on the sheet so guess what I was referring to as " " are zeros. I can do a partial of the range that has only numbers and get the proper result but when I include the whole range with the 0 cells it returns 0. No error values are displayed. The 1st column is formatted the same and has zeros in it and returns a value with the complete range.

  4. #4
    Registered User
    Join Date
    01-29-2007
    Location
    Dobson, NC
    MS-Off Ver
    2000
    Posts
    24

    Re: MIN for different columns of same values produce different results

    Figured it out. I changed the false result in the formulas in the 2nd column to " " rather than 0 and that corrected it.

    =IF($A9=TRUE,$G9,0) to =IF($A9=TRUE,$G9," ")

+ Reply to 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1