+ Reply to Thread
Results 1 to 3 of 3

IF Functions

  1. #1
    Registered User
    Join Date
    02-14-2008
    Posts
    48

    IF Functions

    I've made some changes to the spreadsheet so am posting a slightly different version of this problem - I'm probably just going round in circles! When the completion date is greater than the target date the result in the Situation column should read "Late", unfortunately it doesn't - I can't seem to see the error.

    I attached the revised spreadsheet with example.

    Many thanks
    Attached Files Attached Files

  2. #2
    Forum Expert martindwilson's Avatar
    Join Date
    06-23-2007
    Location
    London,England
    MS-Off Ver
    office 97 ,2007
    Posts
    19,320

    Re: IF Functions

    =IF(B2=0,"",IF(E2="",IF(D2<TODAY(),"Late",IF(D2>TODAY(),"On Target",IF(D2<E2,"Late"))),"On Target"))
    you need to rearrange this the orange bit e2="" is false so the green bit ie the result of false comes into action
    "Unless otherwise stated all my comments are directed at OP"

    Mojito connoisseur and now happily retired
    where does code go ?
    look here
    how to insert code

    how to enter array formula

    why use -- in sumproduct
    recommended reading
    wiki Mojito

    how to say no convincingly

    most important thing you need
    Martin Wilson: SPV
    and RSMBC

  3. #3
    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 Functions

    Is this works for you?

    =IF(B2=0,"",IF(D2<TODAY(),"Late",IF(D2>TODAY(),"On Target",IF(D2<E2,"Late","On Target"))))
    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 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