+ Reply to Thread
Results 1 to 6 of 6

IF statment to verify a number is equal to or between two other numbers

  1. #1
    Registered User
    Join Date
    11-03-2012
    Location
    Erie,Pa
    MS-Off Ver
    Excel 2003
    Posts
    3

    IF statment to verify a number is equal to or between two other numbers

    In cell K3, I need a formula that would verify that cells H3,I3,J3 are all greater than or equal to cell B3 and also less than or equal cell C3, If true a "check" mark would appear in cell K3, if false K3 would be blank.

    Thanks
    Last edited by timothyg; 11-03-2012 at 07:49 AM.

  2. #2
    Forum Moderator Fotis1991's Avatar
    Join Date
    10-11-2011
    Location
    Athens(The homeland of the Democracy!). Greece
    MS-Off Ver
    Excel 1997!&2003 & 2007&2010
    Posts
    13,744

    Re: IF statment to verify a number is equal to or between two other numbers

    Try

    =IF(AND(H3>=B3,I3>=B3,J3>=B3,H3<=C3,I3<=C3,J3<=C3),"check",""))
    Regards

    Fotis.

    -This is my Greek whisper to Europe.

    --Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.

    Advanced Excel Techniques: http://excelxor.com/

    --KISS(Keep it simple Stupid)

    --Bring them back.

    ---See about Acropolis of Athens.

    --Visit Greece.

  3. #3
    Valued Forum Contributor
    Join Date
    08-14-2012
    Location
    India
    MS-Off Ver
    Excel 2007
    Posts
    573

    Re: IF statment to verify a number is equal to or between two other numbers

    Formula: copy to clipboard
    Please Login or Register  to view this content.

  4. #4
    Registered User
    Join Date
    11-03-2012
    Location
    Erie,Pa
    MS-Off Ver
    Excel 2003
    Posts
    3

    Re: IF statment to verify a number is equal to or between two other numbers

    Sorry I was not clear I am looking to place a "check mark" in the cell not the word check.

    Thanks again

  5. #5
    Valued Forum Contributor
    Join Date
    08-14-2012
    Location
    India
    MS-Off Ver
    Excel 2007
    Posts
    573

    Re: IF statment to verify a number is equal to or between two other numbers

    Instead of check, use P and format the font to wingdings 2.

  6. #6
    Registered User
    Join Date
    08-28-2012
    Location
    Sri Lanka
    MS-Off Ver
    Excel 2010
    Posts
    57

    Re: IF statment to verify a number is equal to or between two other numbers

    To be more clear

    Select K3 cell then change the font to Wingdings 2
    =IF(AND(H3>=B3,I3>=B3,J3>=B3,H3<=C3,I3<=C3,J3<=C3),"P",""))

+ 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