Creating A Formula Based On Multiple Outcomes

Hello,
I need help creating a formula that chooses a result based upon multiple outcomes.

The following is what I trying to express:

If High – Entry >= .002 and Low – Entry < .004 = Profit
If Close – Entry >= 0 and Low – Entry < .0040 = Profit

If High – Entry < .002 and Low – Entry >= .004 = Loss
If High – Entry < .002 and Close – Entry < 0 = Loss

I think I expressed what's above correctly. It's what's below that I'm having problems with. I also want the formula to look for the following possibilities.

If Entry < Resistance1 and Entry + .001 <= Resistance1 and If High + .0004 >= Resistance1 = Close at High
If Entry < Resistance1 and Entry + .001 > Resistance1 = No Entry
If Entry > Resistance1 = Resistance1 Non Factor

If Entry < Resistance2 and Entry + .001 <= Resistance2 and If High + .0004 >= Resistance2 = Close at High
If Entry < Resistance2 and Entry + .001 > Resistance2 = No Entry
If Entry > Resistance2 = Resistance2 Non Factor


Please see the attached spreadsheet. I’ve attempted to do it myself, but I got stuck when working with the adding the resistance options.

Any help you can provide would be greatly appreciated.


- Thanking You In Advance

Hello just trying ok.

try this one for the first RESISTANCES 1


=IF(AND(I2<M2,I2+0.001<=M2,J2+0.0004>=M2),"Close at High",IF(AND(I2<M2,I2+0.001>M2),"No Entry",IF(I2>M2,"Non Factor","")))

don't know if i got it correct

Hi.

Maybe, just maybe..something like this??

=IF((AND(O2>=0,002));"Profit";(IF((AND(Q2>=0;P2>-0,004));"Profit";(IF((AND(O2<0,002;P2<=-0,0001;Q2<0));"Loss";IF(AND(I2<M2;I2+0,001<=M2;J2+0,0004>=M2);"Close at High";IF(AND(I2<M2;I2+0,001>M2);"No Entry";IF(I2>M2;"Non Factor";""))))))))

Hope to helps you

Take a look to the example, pls..

Hello artist

also look at this one..
combined resistances with win/loss


resistance12winloss.xls

and btw fotis sample works.