Pull a min value from cells
Results 1 to 4 of 4

Thread: Pull a min value from cells
Thanks Thanks: 0 Likes Likes: 0

  1. #1
    New Member
    Join Date
    Jan 2018
    Posts
    10
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Pull a min value from cells

    This should be basic, but it isn't working for me for some reason.
    I have two cells containing a number from IF formulas, I want the lowest number in another cell.
    The =MIN returns 0, I thought it maybe from the IF formulas??
    So I put an IF which is =IF(O32 O32,IF(P32< O32,P32))
    O32 is 35 at present, P32 is 125, it is returning 125.
    Why I don't know, any ideas on fixing it please?
    Cheers
    Last edited by Spoontang; Jul 22nd, 2019 at 01:21 AM.

  2. #2
    Board Regular
    Join Date
    Mar 2015
    Posts
    3,561
    Post Thanks / Like
    Mentioned
    62 Post(s)
    Tagged
    7 Thread(s)

    Default Re: Pull a min value from cells

    =MIN(O32,P32)

    returns the lower number, but returns 0 if BOTH O32 & P32 are returning a TEXT string

    Numbers in BOTH cells

    Excel 2016 (Windows) 32 bit
    O
    P
    Q
    R
    31
    32
    35
    125
    35
    =MIN(O32,P32)
    33
    Sheet: Sheet1

    Text in BOTH cells

    Excel 2016 (Windows) 32 bit
    O
    P
    Q
    R
    31
    32
    35 125
    0
    =MIN(O32,P32)
    33
    Sheet: Sheet1

    Text in O32, number in P32

    Excel 2016 (Windows) 32 bit
    O
    P
    Q
    R
    31
    32
    35
    125
    125
    =MIN(O32,P32)
    33
    Sheet: Sheet1

  3. #3
    New Member
    Join Date
    Jan 2018
    Posts
    10
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Pull a min value from cells

    Cheers Yongle, I had tried to format the cells to numbers but that didn't work. After your reply I changed the IF formula that was feeding the two cells to pull numbers instead of what probably was adding them as text. Fixed the problem.

  4. #4
    Board Regular
    Join Date
    Mar 2015
    Posts
    3,561
    Post Thanks / Like
    Mentioned
    62 Post(s)
    Tagged
    7 Thread(s)

    Default Re: Pull a min value from cells

    Thanks for the feedback. Glad it worked.

Some videos you may like

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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