+ Reply to Thread
Results 1 to 1 of 1

IF-AND-OR statements.

  1. #1
    Forum Contributor
    Join Date
    12-07-2004
    Posts
    596

    IF-AND-OR statements.

    Problem:

    Checking whether each of the values in List1 (column C) meets the following criteria:
    1. The number must be even.
    2. The number must be smaller than 3 or larger than 8.

    Solution:

    Combining the AND and OR functions in the following IF statement:
    =IF(AND(MOD(A2,2)=0,OR(A2<3,A2>8)),TRUE,FALSE)

    Although the IF is not needed here, since the AND and OR functions return TRUE and FALSE depending on the criteria.

    =AND(MOD(A2,2)=0,OR(A2<3,A2>8))

    Example:

    List1____Result
    2________TRUE
    5________FALSE
    4________FALSE
    10_______TRUE
    Last edited by Paul; 02-15-2012 at 04:59 AM. Reason: Formula was missing the latter half due to forum formatting issues.

+ 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