+ Reply to Thread
Results 1 to 4 of 4

If Greater then today or Blank = Active

  1. 12-11-2012, 12:27 PM #1
    rmharrison
    rmharrison is offline
    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

    Please Login or Register  to view this content.
    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.
    Reply With QuoteRegister To Reply
  2. 12-11-2012, 12:30 PM #2
    Ace_XL
    Ace_XL is offline
    Forum Expert Ace_XL's Avatar
    Join Date
    06-04-2012
    Location
    UAE
    MS-Off Ver
    2016
    Posts
    6,074

    Re: If Greater then today or Blank = Active

    =IF(OR($Z9>TODAY(),$Z9=""),"Active","Discharged")
    Life's a spreadsheet, Excel!
    Say thanks, Click *
    Reply With QuoteRegister To Reply
  3. 12-11-2012, 12:31 PM #3
    Fotis1991
    Fotis1991 is offline
    Forum Expert Fotis1991's Avatar
    Join Date
    10-11-2011
    Location
    Athens(The homeland of the Democracy!). Greece
    MS-Off Ver
    Excel 1997!&2003 & 2007&2010
    Posts
    13,744

    Re: If Greater then today or Blank = Active

    =IF(OR($Z9>TODAY(),$Z9=""), "Active", "Discharged")
    Regards

    Fotis.

    -This is my Greek whisper to Europe.

    --Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.

    Advanced Excel Techniques: http://excelxor.com/

    --KISS(Keep it simple Stupid)

    --Bring them back.

    ---See about Acropolis of Athens.

    --Visit Greece.
    Reply With QuoteRegister To Reply
  4. 12-11-2012, 12:34 PM #4
    rmharrison
    rmharrison is offline
    Registered User
    Join Date
    11-15-2012
    Location
    Hampshire, England
    MS-Off Ver
    Office 2007 and Office MAC 2011
    Posts
    27

    Re: If Greater then today or Blank = Active

    Thanks Both Silly thing I must be tired
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1