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?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. hodkd

    Greater than, less than

    hodkd, Oct 1, 2003, in forum: Microsoft Excel Worksheet Functions
    Replies:
    3
    Views:
    141
    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:
    581
    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,401
    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:
    192
    James O'Toole
    Nov 6, 2003
  5. charlie

    Nested Greater than or less than if statements

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

Share This Page