Results 1 to 2 of 2
  1. #1
    New Lounger
    Join Date
    Feb 2002
    Posts
    1
    Thanks
    0
    Thanked 0 Times in 0 Posts

    =IF function (9.0.3821 SR1)

    Hi,
    I have a simple question that I am sure has been addressed before but I cannot seem to find the answer. I need to compare the number in a single cell with a range of numbers such as =IF(A1=5:10,true,false). Is there any way to make excel accept a range of numbers instead of a single number? I cannot use < or > in this case as the number in the the cell (returned by a formula in the worksheet) could be above or below the range.

  2. #2
    Silver Lounger
    Join Date
    Mar 2001
    Location
    Springfield, Ohio, USA
    Posts
    2,136
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: =IF function (9.0.3821 SR1)

    <pre>=IF(AND(A1>=5,A1<=10),"in range","out of range")</pre>

    <font face="Comic Sans MS">Sam Barrett, CACI </font face=comic>
    <small>And the things that you have heard... commit these to faithful men who will be able to teach others also. 2 Timothy 2:2</small>

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •