+ Reply to Thread
Results 1 to 4 of 4

If then, then this... 2 outcomes with text

  1. #1
    Registered User
    Join Date
    07-14-2021
    Location
    Nashville, TN
    MS-Off Ver
    Microsoft Enterprise
    Posts
    2

    If then, then this... 2 outcomes with text

    Hello. I am trying to create a formula =IF (cell E2) is "this word" then use this date, or IF (cell E2) is "this word" then use this date... Dates will be determined 2 months from F2 =EDATE(F2,2) for one word .... and I need a formula for date for 2 weeks from F2 for the other word...

    aaarrghhh I hope this makes sense.

  2. #2
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS365 Family 64-bit
    Posts
    24,532

    Re: If then, then this... 2 outcomes with text

    Your description is a bit muddled because "this word" and "this word" look like the same word to me, and "this date" and "this date" look like the same date. Do you mean those to be two different words? Maybe something like this?

    Formula: copy to clipboard
    Please Login or Register  to view this content.


    The key thing here is to add 14 to get a date that is two weeks in the future.
    Jeff
    | | |會 |會 |會 |會 | |:| | |會 |會
    Read the rules
    Use code tags to [code]enclose your code![/code]

  3. #3
    Registered User
    Join Date
    07-14-2021
    Location
    Nashville, TN
    MS-Off Ver
    Microsoft Enterprise
    Posts
    2

    Re: If then, then this... 2 outcomes with text

    1,000 thank yousss!!! Sorry if it was hard to figure out!

  4. #4
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS365 Family 64-bit
    Posts
    24,532

    Re: If then, then this... 2 outcomes with text

    You're welcome!

    If your question has been answered please mark your thread as "Solved" so that members will know by looking at the thread title that your problem is solved. Go to the menu immediately above your first post to the thread and click on Thread Tools. From the dropdown menu select "Mark this thread as solved..."

    If a member helped you solve your problem, consider adding to their reputation by clicking on the star icon addreputationiconsmall.jpg below their name.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Formatting text outcomes from formulas
    By Terry-J in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 11-23-2019, 12:43 PM
  2. [SOLVED] IF AND with 3 outcomes
    By RoundaboutCJP in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 11-09-2018, 10:05 AM
  3. All possible Outcomes for C to WIN overall ?
    By Rahzelsmh in forum Excel General
    Replies: 0
    Last Post: 04-06-2016, 11:13 AM
  4. IF STATEMENTS for text and different automatic outcomes/text.
    By filtrox in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 07-16-2014, 08:16 PM
  5. Excel 2007 : Multiple outcomes with text
    By Nicocast in forum Excel General
    Replies: 11
    Last Post: 09-19-2011, 11:25 AM
  6. Replies: 6
    Last Post: 11-19-2009, 08:31 PM
  7. [SOLVED] 256 possible outcomes
    By MarkN in forum Excel General
    Replies: 8
    Last Post: 06-28-2006, 03:40 AM

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