+ Reply to Thread
Results 1 to 4 of 4

AND function not working

  1. 11-05-2015, 06:11 PM #1
    retcol
    retcol is offline
    Registered User
    Join Date
    01-15-2014
    Location
    Tucson, AZ
    MS-Off Ver
    Excel 2003
    Posts
    3

    AND function not working

    Hi All,

    I have been a member for a while, but usually only troll through the existing threads. But I have a problem I can't figure out. I am using the AND function =AND(J2="Yes",AK2="TRUE"). J2 is a text field generated from a drop box. AK2 results are generated by a logical IF formula. When I run the problematic formula, it always comes back as false, even though both the cells are true. What am I missing.
    Reply With QuoteRegister To Reply
  2. 11-05-2015, 06:16 PM #2
    FDibbins
    FDibbins is offline
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    53,048

    Re: AND function not working

    Hi, welcome to the forum

    Try removing the "" from around the TRUE
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford
    Reply With QuoteRegister To Reply
  3. 11-05-2015, 06:52 PM #3
    Tony Valko
    Tony Valko is offline
    Forum Expert Tony Valko's Avatar
    Join Date
    12-31-2011
    Location
    Pittsburgh
    MS-Off Ver
    2002, 2007:2013
    Posts
    18,890

    Re: AND function not working

    Quote Originally Posted by retcol View Post
    AK2 results are generated by a logical IF formula.
    Show us what that formula looks like.
    Biff
    Microsoft MVP Excel
    Keep It Simple Stupid

    Let's Go Pens. We Want The Cup.
    Reply With QuoteRegister To Reply
  4. 11-05-2015, 08:37 PM #4
    FDibbins
    FDibbins is offline
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    53,048

    Re: AND function not working

    @ Tony, seems the "" were the problem, this was marked SOLVED
    Reply With QuoteRegister To Reply
+ Reply to Thread
« 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. Small1, Small2, Small3 marks are same Index function and Cell address function not working
    By bkvenkat in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 06-02-2015, 01:38 AM
  2. IF statement not working with text function and edate function.
    By joshnathan in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 11-04-2013, 10:26 AM
  3. Excel Match Function not working with Right function.
    By swap579579 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 05-16-2013, 09:00 PM
  4. [SOLVED] Using the Split function with another function incorporated is not working correctly
    By highlystrung in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 05-06-2013, 03:51 PM
  5. MATCH function within INDIRECT function not working
    By mgerada in forum Excel General
    Replies: 2
    Last Post: 09-04-2011, 08:37 AM
  6. Have an array function and then a '=continue' function that are not working.
    By WilliamGCash in forum Excel General
    Replies: 4
    Last Post: 12-21-2010, 04:34 PM
  7. [SOLVED] Working with Arrays, pasing from function to function
    By mikebres in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-27-2006, 01:40 PM

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