+ Reply to Thread
Results 1 to 2 of 2

IF AND statement-how this can be tweaked

  1. #1
    Registered User
    Join Date
    11-05-2007
    Posts
    1

    IF AND statement-how this can be tweaked

    I am trying to use the following to give me back a result which indicates it there is a date in both cells, then give me back a "Yes". W12 and T12 have or may not have dates.
    Somehow, this formula did/does not work.

    =IF(AND(W12>0,T12>0),"YES"," ")

    Any idea how this can be tweaked so that it will work? Alternatively, what am I doing wrong?

    Arod65

  2. #2
    Forum Expert daddylonglegs's Avatar
    Join Date
    01-14-2006
    Location
    England
    MS-Off Ver
    2016
    Posts
    14,675
    What do you have in T12 and W12, are there formulas in those cells, if so what are they?

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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