+ Reply to Thread
Results 1 to 4 of 4

IF AND Formula not working as expected

Hybrid View

  1. #1
    Registered User
    Join Date
    11-30-2013
    Location
    UK
    MS-Off Ver
    Excel 2007
    Posts
    58

    IF AND Formula not working as expected

    =IF(AND(A12="9599",F12="Linkjoping"),"YES","NO")

    I have used the above formula and in the specified cells they do contain these values - however, the result is always 'NO'?

  2. #2
    Forum Expert
    Join Date
    05-05-2015
    Location
    UK
    MS-Off Ver
    Microsoft Excel for Microsoft 365 MSO (Version 2402 Build 16.0.17328.20068) 64-bit
    Posts
    30,693

    Re: IF AND Formula not working as expected

    Try

    =IF(AND(A12=9599,F12="Linkjoping"),"YES","NO")

    i.e, A12 is NOT text but formatted as GENERAL or NUMBER

  3. #3
    Forum Expert José Augusto's Avatar
    Join Date
    10-29-2014
    Location
    Portugal
    MS-Off Ver
    2013-2016
    Posts
    3,329

    Re: IF AND Formula not working as expected

    Try
    =IF(AND(A12=9599,F12="Linkjoping"),"YES","NO")

  4. #4
    Registered User
    Join Date
    11-30-2013
    Location
    UK
    MS-Off Ver
    Excel 2007
    Posts
    58

    Re: IF AND Formula not working as expected

    Thanks both

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] MODE formula not working as expected
    By JakeMann in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 11-14-2017, 02:18 PM
  2. Replies: 3
    Last Post: 07-29-2017, 04:32 AM
  3. [SOLVED] Formula in CF not working as expected
    By ImranBhatti in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 05-10-2017, 07:58 AM
  4. [SOLVED] Formula not working as expected
    By nalamarmite1 in forum Excel General
    Replies: 4
    Last Post: 03-08-2016, 08:34 AM
  5. [SOLVED] CountIfS not working as expected
    By rschoenb in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 11-12-2014, 11:45 PM
  6. vlookup/if formula not working as expected
    By Shocked in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 09-11-2008, 10:06 AM
  7. For Each Statement not working as expected
    By Jacqui in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-02-2005, 06:20 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1