Results 1 to 6 of 6

Advice required for this function

Threaded View

localhost Advice required for this... 11-03-2008, 07:55 PM
daddylonglegs Try ... 11-03-2008, 08:15 PM
localhost The first part of the code... 11-03-2008, 08:28 PM
daddylonglegs Your description doesn't... 11-03-2008, 08:41 PM
localhost That's right. Apologies for... 11-04-2008, 03:00 AM
localhost Alright, did some research... 11-05-2008, 06:04 AM
  1. #1
    Registered User
    Join Date
    11-26-2004
    Location
    Dallas, TX
    MS-Off Ver
    Office 2008 for Mac & Office 2007
    Posts
    17

    Advice required for this function

    I've got the following function that check if each cell has a date greater than TODAY(). If result is true, it'll display "NO GO". Otherwise, it'll display "GO".

    I would want to improve on it such that if any of the 'B5:F5' cell is empty, it'll display "Incomplete" instead of "No Go".

    Any ideas?

    =IF(AND(B5>=TODAY();C5>=TODAY();D5>=TODAY();E5>=TODAY();F5>=TODAY());"GO";"NO GO")
    Last edited by localhost; 11-05-2008 at 06:06 AM.

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