Results 1 to 9 of 9

IF Statements Function Properly When Separate but Not When Combined with OR Statement

Threaded View

chrisboughter IF Statements Function... 08-27-2014, 06:29 PM
TMS Re: IF Statements Function... 08-27-2014, 07:13 PM
Yogi52o Re: IF Statements Function... 08-27-2014, 07:15 PM
chrisboughter Re: IF Statements Function... 08-27-2014, 07:39 PM
TMS Re: IF Statements Function... 08-27-2014, 07:54 PM
chrisboughter Re: IF Statements Function... 08-27-2014, 09:13 PM
chrisboughter Re: IF Statements Function... 08-27-2014, 10:43 PM
TMS Re: IF Statements Function... 08-28-2014, 02:37 AM
TMS Re: IF Statements Function... 08-28-2014, 02:32 AM
  1. 08-27-2014, 06:29 PM #1
    chrisboughter is offline
    Registered User
    Join Date
    02-14-2012
    Location
    Cincinnati, Ohio
    MS-Off Ver
    Excel 2003
    Posts
    18

    IF Statements Function Properly When Separate but Not When Combined with OR Statement

    This Works > =IF(VLOOKUP(A2,BrokerList,1,FALSE)=A2,"Broker","Non-Broker")
    This Works > =IF(LEFT(A2,2)="39","Broker","Non-Broker")
    This Does Not Work > =IF(OR(VLOOKUP(A2,BrokerList,1,FALSE)=A2,LEFT(A2,2)="39"),"Broker","Non-Broker")
    Attached Files Attached Files
    Last edited by chrisboughter; 08-27-2014 at 07:41 PM. Reason: Solved
    Reply With QuoteRegister To Reply
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Create consolidated income statement from separate statements
    By max3732 in forum Excel Programming / VBA / Macros
    Replies: 22
    Last Post: 07-08-2014, 12:41 PM
  2. Combined if statements
    By DCRAIG3389 in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 03-06-2014, 06:41 PM
  3. combined (nested?) IF statements
    By tjl in forum Excel General
    Replies: 1
    Last Post: 06-27-2012, 01:14 PM
  4. Vlookup, If statement and Indirect combined function help
    By ms_tee in forum Excel General
    Replies: 2
    Last Post: 10-30-2011, 05:15 PM
  5. Excel 2007 : Using an if statement combined with a networkdays function
    By bingo7 in forum Excel General
    Replies: 3
    Last Post: 09-24-2009, 07:19 PM

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1