Profit/loss targets

Hi, I need some help!

I'm looking at tick data of stock prices

I have, date, open, high/low, high/low, close

3rd (C) and 4th (D) column (high or low) are either high or low. Meaning since this is tick, in column C and D there is a value for either a high or low. If the low came first then column C will have that value.. And the high will be in column D.

Then I have profit targets and stop loss target. I'm trying to come up with a logic that will tell me if my profit target was hit first or if my profit target was hit first.

Let's say if column C had the high first and my profit target was less than the high. Then that means my profit target was hit. Or if the low came first in column C and my stop loss was larger than the low.. That means my stop loss was hit (since the price kept on going down.. Below my stoploss)

Any thoughts?? Thx!

Column f is where my profit target is.
Column G is where my stop loss is.

Also keep in mind that there can in instances where neither profit or stoploss were ever hit. Meaning profit target was higher than the high and stoploss was less than the low!!!

this is what i have.. but it doesnt work properly

=+IF(AND(F2<=MAX(C2:D2),G2>MIN(C2:D2)),F2/B2-1,IF(G2<=MIN(C2:D2),G2/B2-1,0))