greater than or less than if statements

Discussion in 'Microsoft Excel Worksheet Functions' started by Guest, Jan 25, 2006.

  1. Guest

    Guest Guest

    How do you make a formula to state if a number is greater than one number but
    less than another number. My example is: if d10 is greater than b20 but less
    than b20+1, then b10, if not, b20.
     
    Guest, Jan 25, 2006
    #1
    1. Advertisements

  2. Guest

    SteveG Guest

    SteveG, Jan 25, 2006
    #2
    1. Advertisements

  3. Guest

    Bob Phillips Guest

    =IF(AND(D10>B20,D10<B20+1)<B10,B20)

    --

    HTH

    Bob Phillips

    (remove nothere from the email address if mailing direct)

    "ERG" <> wrote in message
    news:...
    > How do you make a formula to state if a number is greater than one number

    but
    > less than another number. My example is: if d10 is greater than b20 but

    less
    > than b20+1, then b10, if not, b20.
     
    Bob Phillips, Jan 25, 2006
    #3
  4. Guest

    Guest Guest

    "ERG" wrote:

    > How do you make a formula to state if a number is greater than one number but
    > less than another number. My example is: if d10 is greater than b20 but less
    > than b20+1, then b10, if not, b20.
     
    Guest, Jan 25, 2006
    #4
  5. Guest

    Guest Guest

    =IF((B20 + 1) > D10,B20,D10)


    "ERG" wrote:

    > How do you make a formula to state if a number is greater than one number but
    > less than another number. My example is: if d10 is greater than b20 but less
    > than b20+1, then b10, if not, b20.
     
    Guest, Jan 25, 2006
    #5
  6. Guest

    Guest Guest

    Try =IF(D10<B20+1,IF(D10>B20,D10,B20),B20)

    "ERG" wrote:

    > How do you make a formula to state if a number is greater than one number but
    > less than another number. My example is: if d10 is greater than b20 but less
    > than b20+1, then b10, if not, b20.
     
    Guest, Jan 25, 2006
    #6
    1. Advertisements

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments (here). After that, you can post your question and our members will help you out.
Similar Threads
  1. hodkd

    Greater than, less than

    hodkd, Oct 1, 2003, in forum: Microsoft Excel Worksheet Functions
    Replies:
    3
    Views:
    409
    hodkd
    Oct 2, 2003
  2. Guest

    Formula: If less than X but greater than Y...

    Guest, Oct 24, 2003, in forum: Microsoft Excel Worksheet Functions
    Replies:
    2
    Views:
    1,653
    Michael Puk
    Oct 25, 2003
  3. Guest

    "Greater than but less than" formula

    Guest, Oct 26, 2003, in forum: Microsoft Excel Worksheet Functions
    Replies:
    8
    Views:
    9,999
    joeldault
    Jan 3, 2010
  4. James O'Toole

    Greater than, less than formula

    James O'Toole, Nov 6, 2003, in forum: Microsoft Excel Worksheet Functions
    Replies:
    3
    Views:
    455
    James O'Toole
    Nov 6, 2003
  5. apfreak

    Greater than or less than.

    apfreak, Dec 19, 2003, in forum: Microsoft Excel Worksheet Functions
    Replies:
    8
    Views:
    321
  6. Reuben

    Greater Than or Less Than

    Reuben, Jan 2, 2004, in forum: Microsoft Excel Worksheet Functions
    Replies:
    1
    Views:
    236
    Bob Phillips
    Jan 2, 2004
  7. Guest

    Greater than & Less than

    Guest, Jan 16, 2004, in forum: Microsoft Excel Worksheet Functions
    Replies:
    1
    Views:
    222
    Norman Harker
    Jan 16, 2004
  8. charlie

    Nested Greater than or less than if statements

    charlie, Jun 26, 2009, in forum: Microsoft Excel Worksheet Functions
    Replies:
    5
    Views:
    1,586
    Rick Rothstein
    Jun 26, 2009
Loading...