Results 1 to 2 of 2

Thread: Complex IF Statement help please!
Thanks Thanks: 0 Likes Likes: 0

  1. #1
    New Member
    Join Date
    Nov 2018
    Posts
    1
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Complex IF Statement help please!

    Greetings,
    Im working with a template that has the following expression:

    =IF(AND($B10="Goal",H$5>=$E10,H$5<=$E10+$F10-1),2,IF(AND($B10="Milestone",H$5>=$E10,H$5<=$E10+$F10-1),1,""))

    The value in Column F is currently # of days - I'd like to change that to an End Date and would really like some help - not sure where to begin! IN the example above, # of days is 3 - My ideal state is to have this as a date format such as 2018-11-26

    The result of the formula is a gantt chart.

    Thanks in advance for your suggestions!

  2. #2
    MrExcel MVP
    Moderator
    Fluff's Avatar
    Join Date
    Jun 2014
    Location
    Chippenham
    Posts
    29,229
    Post Thanks / Like
    Mentioned
    483 Post(s)
    Tagged
    49 Thread(s)

    Default Re: Complex IF Statement help please!

    Assuming E10 is a date, how about
    =IF(AND($B10="Goal",H$5>=$E10,H$5<=$F10),2,IF(AND($B10="Milestone",H$5>=$E10,H$5<=$F10),1,""))
    - Posting Data try one of these tools
    - Posting guidelines, forum rules and terms of use
    - Read the FAQs

    Running Office 365 on Win 10

Some videos you may like

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •