+ Reply to Thread
Results 1 to 2 of 2

If and or statement

  1. #1
    Registered User
    Join Date
    08-31-2011
    Location
    Salt Lake City, UT
    MS-Off Ver
    Excel 2003
    Posts
    14

    If and or statement

    I need help with the following statement that keeps throwing an error:

    =IF(AND(CDR!Q2>=DATE('POC CDR'!O4,'POC CDR'!P4,'POC CDR'!Q4),CDR!Q2<=DATE('POC CDR'!O5,'POC CDR'!P5,'POC CDR'!Q5),(CDR!E2='mBox PCDR'!K30))(or(CDR!G2='mBox PCDR'!I4)(CDR!G2='mBox PCDR'!I5)(CDR!G2='mBox PCDR'!I6)(CDR!G2='mBox PCDR'!I7)(CDR!G2='mBox PCDR'!I8)(CDR!G2='mBox PCDR'!I9)(CDR!G2='mBox PCDR'!I10),CDR!F2,"0")

    This is supposed to to first check against a date range and the value of a cell and then an or to validate against multiple cells.

    Thanks in advance!

    -EW

  2. #2
    Valued Forum Contributor tlafferty's Avatar
    Join Date
    04-08-2011
    Location
    United States, Tacoma, WA
    MS-Off Ver
    Excel 2010, Excel 2013 Customer Preview
    Posts
    1,112

    Re: If and or statement

    This formula may be able to be simplified quite a bit. Can you explain in step by step terms exactly what you'd like to have happen and attach a sample workbook? Part of what's going on is you've got your arguments for the AND function set up incorrectly, but it's hard to correct without knowing for certain what you'd like to accomplish.
    If your question has been satisfactorily addressed, please consider marking it solved. Click the Thread Tools dropdown and select Mark thread as solved.
    Also, you might want to add to the user's reputation by clicking the star icon in the lower left corner of the post with the answer- it's why we do what we do...

    Thomas Lafferty
    Analyst/Programmer

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

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