+ Reply to Thread
Results 1 to 4 of 4

If statement with a range.

  1. #1
    Registered User
    Join Date
    10-05-2011
    Location
    Cincinnati, USA
    MS-Off Ver
    Excel 2010
    Posts
    5

    If statement with a range.

    Hello everyone,

    I am very very new to using excel and I need help with ranges.
    For example:

    I have numbers A, B, C in cells A3,B3,C3 respectively.

    If number B is less than A it should show the number from A3 in the answer field
    If number B is between the A & C then B3 is in the answer field
    If number B is larger than C then C3 is in the answer field.

    I know this should be simple, but for the life of me everything I have tried it has said to many arguments or whatever.

    Thanks in advance for any help.

  2. #2
    Valued Forum Contributor
    Join Date
    10-13-2010
    Location
    Sunderland, England
    MS-Off Ver
    Excel 2007 (Home) / 2003 (Work)
    Posts
    740

    Re: If statement with a range.

    =if(B3>C3,C3, if(B3<A3,A3,B3))

    This assumes the number is A is always less than the number in C?

  3. #3
    Forum Expert daddylonglegs's Avatar
    Join Date
    01-14-2006
    Location
    England
    MS-Off Ver
    2016
    Posts
    14,675

    Re: If statement with a range.

    I also assume C3 > A3 in which case you can use

    =MEDIAN(A3,B3,C3)
    Audere est facere

  4. #4
    Registered User
    Join Date
    10-05-2011
    Location
    Cincinnati, USA
    MS-Off Ver
    Excel 2010
    Posts
    5

    Re: If statement with a range.

    Thank you both, using the median function never even crossed my mind. This might actually be better for what I had in mind. again thank you so much

+ 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