Thanks Thanks:  0
Likes Likes:  0
Results 1 to 4 of 4

Thread: Help with "If greater than, but less than" statement.

  1. #1
    New Member
    Join Date
    Jan 2003
    Location
    First Health
    Posts
    45
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Help with "If greater than, but less than" statement.

    Hi, all - I have been banging my head on the desk over this one...it's gotta be so simple, right? Have searched online, and on Mr. Excel, but still can't get this right.

    I need a formula in cell L3 that says "IF cell K3 is greater than 25 but less than 30, K3, otherwise, blank." Cell K3 currently contains the value 30. My formula in L3 currently is =IF(K3>25,K3,IF(K3<30,K3," ")). Cell L3 is displaying 30...so the formula isn't working the way I need it to.

    Thanks in advance!

  2. #2
    Board Regular
    Join Date
    Feb 2010
    Location
    London, UK
    Posts
    9,093
    Post Thanks / Like
    Mentioned
    21 Post(s)
    Tagged
    3 Thread(s)

    Default Help with "If greater than, but less than" statement.

    Try:
    Code:
    =IF(AND(K3>25,K3<30),K3,"")


  3. #3
    New Member
    Join Date
    Jan 2003
    Location
    First Health
    Posts
    45
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Talking Re: Help with "If greater than, but less than" statement.

    Huzzah! Thanks, JackDanIce!

    I knew the solution would be simple, and I even thought it might use AND, but it seemed everything kept pointing to nested IF statements...so I never quite got there.

    Very grateful!

  4. #4
    Board Regular
    Join Date
    Feb 2010
    Location
    London, UK
    Posts
    9,093
    Post Thanks / Like
    Mentioned
    21 Post(s)
    Tagged
    3 Thread(s)

    Default Re: Help with "If greater than, but less than" statement.

    You're welcome


Some videos you may like

User Tag List

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
  •