+ Reply to Thread
Results 1 to 2 of 2

Measuring a graph crossing if x is met

  1. #1
    Forum Contributor
    Join Date
    01-26-2018
    Location
    London, England
    MS-Off Ver
    365
    Posts
    311

    Measuring a graph crossing if x is met

    Hello again guys,

    I'm trying to build a formula that somehow can vary how it reads a "crossing". Atm I have a series of formulas that calculate the location of the "dip" on the graph (if it's above its starting value). I want excel to then calculate if a level is breached (in relation to the dip) - forgeting the previous points of the graph

    This is the perfect result:

    1KNuqaojRjKAeFDQelH1vQ.png

    Note the dip occurs @ 5, a formula adds 2% to this & if that level gets breached (& also finishes above that level) be labeled as "Winner".

    However, currently my forumla calculates it like this:

    PfA5lcdTT_uF_FfcQHlafA.png

    This is incorrectly lablled as a "Loser", because the breach should only be valid if it occurs after the dip

    Here's another diagram, plus the workbook with all the calculations.

    zqSYWdhHRdS3-hKWuH5E3A.png

    This has bugged me all day! so any help would be much appreciated - feel free to ask for clarification on anything

    Thanks
    Mdn
    Attached Files Attached Files
    Last edited by Median; 02-23-2018 at 04:21 PM.

  2. #2
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 2019
    Posts
    17,567

    Re: Measuring a graph crossing if x is met

    If I understand the part about 'breaching' and 'finishing above' the 'dip'+2% threshold, then perhaps this will be of some help.
    1) Paste the following formula into cell C10: =IF(AND(D6>$B6,D6<C6,D6<E6),D6*1.02,"")
    2) drag the fill handle over to cell F10,
    3) while C10:F10 are still highlighted drag the fill handle of F10 down to F13.
    4) Paste the following formula into cell C14: =IF(C10="","",IF($G6>C10,"Winner","Loser"))
    5) drag the fill handle over to F14 then down to F17.
    Steps 1-3 establish the value of the 'dip'+2%.
    Steps 4 and 5 establish winners and losers based on whether or not the final value is more than the 'dip'+2% value.
    Let us know if you have any questions.
    Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.

+ 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. Crossing over different sheets
    By Huggyd in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 11-22-2015, 10:20 PM
  2. X and Y axis crossing
    By Terri Earley in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 10-24-2015, 01:03 PM
  3. [SOLVED] The value near zero is required when two curves are crossing.
    By thilag in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 08-12-2014, 04:31 AM
  4. Data crossing
    By atzaguga in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 01-15-2012, 02:03 PM
  5. Excel 2007 : Crossing the date of expiration
    By quaint_paradox in forum Excel General
    Replies: 1
    Last Post: 12-15-2011, 07:29 PM
  6. Measuring length of x-axis in a graph
    By Yohans in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 09-01-2010, 01:12 AM
  7. [SOLVED] Crossing Applications - Possible?
    By Marty in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 09-26-2005, 11:05 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