+ Reply to Thread
Results 1 to 2 of 2

Display formula result if cell is X cells away from text value

  1. #1
    Registered User
    Join Date
    10-29-2013
    Location
    Home
    MS-Off Ver
    Excel 2003
    Posts
    1

    Display formula result if cell is X cells away from text value

    First time posting, and I do not know the keywords to search for this issue. I'll describe the best I can.

    I would like to have a variable timeline that will change the contents & visibility of the cell based on a value.

    The attached example shows 3 scenarios that I would like the results to be, by only changing the Months After Launch cell.

    Example A, is 3 months so there is calculation & display 3 cells over
    Example B, is 5 months so there is calculation & display 5 cells over
    Example C, is 7 months so there is calculation & display 7 cells over

    How can I make this dynamic?

    Thanks in advance,
    Attached Files Attached Files

  2. #2
    Forum Expert JBeaucaire's Avatar
    Join Date
    03-21-2004
    Location
    Bakersfield, CA
    MS-Off Ver
    2010, 2016, Office 365
    Posts
    33,492

    Re: Display formula result if cell is X cells away from text value

    Put this formula in E7 (after the cell with "Launch"), then copy to the right. You can copy down as well, but only paste into cells to the RIGHT of the word LAUNCH on any row.

    =IF(DATEDIF(INDEX($D$6:D$6,MATCH("Launch", $D7:D7, 0)), E$6, "m")=$B$3, 200, "-")


    Now change the value in B3 to other values and the "$200" will move on each row.
    _________________
    Microsoft MVP 2010 - Excel
    Visit: Jerry Beaucaire's Excel Files & Macros

    If you've been given good help, use the icon below to give reputation feedback, it is appreciated.
    Always put your code between code tags. [CODE] your code here [/CODE]

    ?None of us is as good as all of us? - Ray Kroc
    ?Actually, I *am* a rocket scientist.? - JB (little ones count!)

+ 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. Is it possible to have 1 cell display a result from a choice of other cells?
    By Conundrum02 in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 02-06-2013, 06:53 PM
  2. Display numerical result of a cell with Text as well
    By davidcrawt in forum Excel General
    Replies: 3
    Last Post: 11-26-2012, 03:27 PM
  3. Formula in cell but does not display result
    By glamint in forum Excel General
    Replies: 1
    Last Post: 08-17-2012, 02:08 AM
  4. Match text in mulitple cells and display result
    By mrcois in forum Excel - New Users/Basics
    Replies: 2
    Last Post: 04-22-2010, 01:58 AM
  5. Display result in same cell as formula
    By J Strang in forum Excel General
    Replies: 2
    Last Post: 08-21-2006, 02:40 PM

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