Results 1 to 4 of 4

If Greater then today or Blank = Active

Threaded View

  1. #1
    Registered User
    Join Date
    11-15-2012
    Location
    Hampshire, England
    MS-Off Ver
    Office 2007 and Office MAC 2011
    Posts
    27

    If Greater then today or Blank = Active

    Hi all my mind has gone blank, and yet I followed the help within excel but still getting '#NAME?'

    What I have is

     =IF(OR($Z9>TODAY, $Z9=""), "Active", "Discharged")
    What i'm trying to get is IF $Z9 is blank or greater then today it equals "Active" but if Fulse then it equals "Discharged"

    I know I'm not seeing something but its going straight over my head.

    PLEASE HELP

    Regards

    Rich
    Last edited by rmharrison; 12-11-2012 at 12:29 PM.

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