+ Reply to Thread
Results 1 to 2 of 2

Help on formule

  1. #1
    Forum Contributor
    Join Date
    08-20-2013
    Location
    LX
    MS-Off Ver
    Office 2019
    Posts
    164

    Help on formule

    I have a formula that works great, but I want to add an other thing. The actual formula is:

    =IF(OR(C20="",K20=""),"",IF(AND(K20<>"",N20=""),IF(K20>=TODAY(),"CAPA IN TIME","CAPA OVERDUE"),IF(N20<=K20,"YES","NO")))

    What I want is when I have the value N.A. in I20 that it returns me "Yes" if someting else is in I20 then ""

    Thanks for ur help

  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
    28,007

    Re: Help on formule

    Try

    =IF(I20<>"N.A",IF(OR(C20="",K20=""),"",IF(AND(K20<>"",N20=""),IF(K20>=TODAY(),"CAPA IN TIME","CAPA OVERDUE"),IF(N20<=K20,"YES","NO"))),"Yes")

    on assumption that IF i20 contains N.A then no other checking is done: if it is blank execute other IF statements.


    You cannot have "Yes" or blank answer in the above formula as an IF only has two conditions so you cannot check C , K or N.

    =IF(I20="N.A","Yes","")

+ 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] Vba sum formule
    By brainzlp in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 10-29-2015, 10:21 AM
  2. Formule =ALS
    By mazaike in forum Non English Excel
    Replies: 3
    Last Post: 06-27-2015, 07:55 AM
  3. Formule =ALS
    By mazaike in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 06-09-2015, 05:37 AM
  4. More than one value in MID formule
    By Teddymanne in forum Excel Formulas & Functions
    Replies: 14
    Last Post: 08-08-2014, 12:13 PM
  5. dynamic formule
    By glda19 in forum Excel General
    Replies: 2
    Last Post: 12-25-2012, 01:06 PM
  6. Need a formule for this....
    By Jerin John in forum Excel General
    Replies: 1
    Last Post: 03-23-2011, 12:38 AM
  7. formule / functie
    By shamrockEd in forum Non English Excel
    Replies: 3
    Last Post: 07-31-2009, 03:11 AM

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