You can use this formula to determine intersection within each segment.
=IF(AND(C13>=$I$33,C14<=$I$33),TREND(B13:B14,C13:C14,$I$33),FALSE)
You can use this formula to determine intersection within each segment.
=IF(AND(C13>=$I$33,C14<=$I$33),TREND(B13:B14,C13:C14,$I$33),FALSE)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks