• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Comparing value to other cells

spattedkow

New Member
Hello! I am looking for some help on a formula to help complete a task.

Column A and B are a series for me, so 25-28, 32-37, etc. I'm checking if Column C is between any of the series listed and outputting to Column D. I'm currently using nested if statements, but I could have 150 rows of series to check, so that is becoming inefficient. Is there an easier way to do this?

252824No
323735Yes
4852
6788
 
You could simply multiply the comparisons together using a formula such as:

=CHOOSE((C1>A1)*(C1<B1)+1,"No","Yes")

Depending on your needs for including the values in columns A or B the "<" or ">" can be replaced with "<=" or ">=" as needed.

Hope that helps.

Regards,
Ken
 
Back
Top