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.