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
Bookmarks