Results 1 to 3 of 3

Formula Syntax Help to add another check (IF/AND)

Threaded View

  1. 04-13-2016, 08:28 AM #1
    robertguy
    robertguy is offline
    Forum Contributor
    Join Date
    02-09-2004
    Location
    Cardiff - Wales - UK
    MS-Off Ver
    2013
    Posts
    475

    Question Formula Syntax Help to add another check (IF/AND)

    Hi

    can anyone please advise me of the syntax required to amend the formula in column ‘T’ (starting in cell ‘T4’) to check if cells A4 contains a number and not ‘N/A’ (which the formula does currently) but also check if cell ‘K4’ is empty (i.e. does not contain a date) and if so include in the formula below S4 = “No Baseline Date”

    =IF(ISNA(A4),"",IF(AND(S4="Not Due",$F$1-K4>0),"Missed",S4))Please attached Example file

    Many thanks in advance for any assistance received

    Regards


    Rob
    Attached Files Attached Files
    Rob
    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. [SOLVED] Quick Syntax Check
    By HarryGreenwood in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 01-06-2015, 01:24 PM
  2. [SOLVED] Simple Worksheet_Change Event Syntax Check
    By AlvaroSiza in forum Excel Programming / VBA / Macros
    Replies: 13
    Last Post: 02-06-2014, 08:04 PM
  3. IF formula Syntax
    By Mossy in forum Excel General
    Replies: 4
    Last Post: 06-23-2009, 04:57 PM
  4. check this sql syntax?
    By winniewang11 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 08-18-2008, 04:13 AM
  5. Formula Syntax Help
    By Ikaabod in forum Excel General
    Replies: 2
    Last Post: 04-21-2006, 10:35 AM
  6. [SOLVED] What is the syntax to check if a date occurred before a referance.
    By Hugh@cat in forum Excel General
    Replies: 2
    Last Post: 04-12-2005, 04:06 PM
  7. [SOLVED] Syntax to check protected status of a worksheet?
    By slingsh0t@hotmail.com in forum Excel General
    Replies: 2
    Last Post: 01-18-2005, 11:06 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1