Help with an =If statement

[DSully82]

I've been back-testing a stock pattern and I'm having trouble getting my one of my columns to read give me the value I want. I want the following to be true if all of these conditions are met:

F3>0

G3>0

J3<F3

J3>0 and J3<11


Here is what I have: =IF(F3>0,"X",IF(G3>0,"X",IF(J3<F3,"X",IF(AND(J3>0,J3<11),1,"X"))))

The only part of the code that isn't working is the J3<F3. In other words, I noticed in one of my cells I had a 1 in J3, but when I added a 2 to F3 the cell came back as X (false).

I also tried: =IF(J3<F3,AND(F3>0,AND(G3>0,AND(J3>1,J3<11),1,"X"))) but this just gave me the word "false" which isn't what I want. I want a 1 for true, and X for false.

Any help is appreciated.

[bebo021999]

Not 100% understanding, but try:

=IF(AND(F3>0,G3>0,J3<F3,J3>0,J3<11),1,"X")

[bebo021999]

Or shorter, with J3>0 and F3>J3, then F3>0 is unneeded

=IF(AND(G3>0,J3<F3,J3>0,J3<11),1,"X")

[DSully82]

Nah, that wasn't it, still looking.

Basically, I'm trying to identify times where price action produces a signal. Then,I'm watching 2 price targets,
and then an area lower below the signal. I want the cell to tell me when price goes straight up to price target
1 without going down to the lower zone. The problem I'm having is any time that price action goes up to PT1, then
back down to lower zone, it invalidates my current formula.

Super annoying. If I can clarify anything to make it clearer, let me know.

[bebo021999]

Please attach a sample workbook (not a picture or pasted copy). Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

[DSully82]

Okay, I'm attaching the example that tipped me off. Cells F2 and G2 comprise of a zone where I would consider entries("E1" and "E2"), J2, K2, and L2 are price targets (PT1-3). In this example, price went up and touched PT1 and PT2, but not PT3, so cells J2 and K2 got a "1" for the number of days it took to reach those PTs. But then price came back down below "E1" and "E2" a few days later.

Cell V2 is the formula in question. It is supposed to be a true/false on whether price action hit PT1 without hitting E1/E2, and within 10 days from the signal. Basically, this cell is telling my whether or not price skipped my entry zone or not within a period of 10 days. It should read as a "1" as it is true in this case. Price action didn't hit E1/E2 until 4 days after hitting PT1, but currently produces an "X" (false).

Thanks again, let me know if I can explain anything else.

[bebo021999]

It is so hard to understand. Column M to V contain formulas those might be not working.
What I need is the MANUAL INPUT for each scenarios of Es and PTs.
Fill in scenarios template I made in attachment.

[DSully82]

Whoops, meant to post this last night. Here are the scenarios.