1. Welcome to Chandoo.org Forums. Short message for you

    Hi Guest,

    Thanks for joining Chandoo.org forums. We are here to make you awesome in Excel. Before you post your first question, please read this short introduction guide. When posting or responding to questions please remember our values at Chandoo.org are: Humility, Passion, Fun, Awesomeness, Simplicity, Sharing Remember that we have people here for whom English is not there first language and we need to allow for this in our dealings.

    Yours,
    Chandoo
  2. Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  3. When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

If formula

Discussion in 'Ask an Excel Question' started by vmohan1978, Feb 13, 2018.

  1. vmohan1978

    vmohan1978 Member

    Messages:
    66
    I want to update the status based on the formulas.

    In Column B I have dates and In Column C next to date will be blank or YES.

    In column "D" I want the output based on the following requirements.

    example :

    If C2 "YES" then output will be completed
    C2 is blank and assume today is 13/2/2018 and date in B1 is 22/2/2018 If today is lessthan B1 then want the output to be "On track" or "Delay".
  2. AliGW

    AliGW Active Member

    Messages:
    268
    Please clarify what you require if C2 is "Yes" - what do you mean by "output will be completed"?

    =IF(AND(C2="",TODAY()<B1),"On Track","Delay")
  3. vmohan1978

    vmohan1978 Member

    Messages:
    66
    Aligw,

    I am preparing the performance review status. If the performance review is completed on the mentioned date B1 then in C1 will reflect Completed.

    Find attached the file hope it will give more clarity.

    Attached Files:

  4. AliGW

    AliGW Active Member

    Messages:
    268
    In D4 copied down:

    =IF(C4="Yes","Completed",IF(C$1<A4,"On Track","Delay in Process"))
    Rasheed likes this.
  5. vmohan1978

    vmohan1978 Member

    Messages:
    66
    Thank you AliGW, formula working perfectly. Thank you very much for your time .
  6. AliGW

    AliGW Active Member

    Messages:
    268
    No problem - glad to have helped. :)

Share This Page